Message-ID: <435E65A1.7030907@e9.com>
Date: Tue, 25 Oct 2005 12:04:33 -0500
From: Louis Castoria <louisc@e9.com>
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: libpq status question
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I'm confused about something and need some help.  I wrote a c routine 
that uses libpq.  The result codes  are good when I use a select or 
insert.  if  I use an update  sql command  string like "update 
largetable set t01='update1', t02='update2' where mainkey='12'" and the 
mainkey of 12 does not exist the result code is a 0 if the mainkey 
exists I get a result of 0.  How can I tell if the update was 
successfully or not.  Here is the code.

void                                                                           

pgsql_exec_query( int *dbhandle, char *query, int *qryhandle, int 
*status ) { 
        char 
*r,*n=query;                                                     
        int nfields, i, 
j;                                                    
        PGconn *conn = (PGconn 
*)*dbhandle;                                   
        PGresult 
*res;                                                        
        while ( *n != ';' || *(n+1) != ';' ) 
n++;                             
        
*n=0;                                                                 
        res = 
0;                                                              
        res = PQexec(conn, 
query);                                            
        printf("Result = %d ", (int) 
res);                                    
        *status = 
PQresultStatus(res);                                        
        printf("status = %f", (int) 
status);                                  
        *qryhandle = (int) 
res;                                               
}