libpq status question
| От | Louis Castoria |
|---|---|
| Тема | libpq status question |
| Дата | |
| Msg-id | 435E65A1.7030907@e9.com обсуждение исходный текст |
| Ответы |
Re: libpq status question
|
| Список | pgsql-interfaces |
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;
}
В списке pgsql-interfaces по дате отправления: