PQresultStatus use for error handling.
*** This is a part of the postgres manual ***
PQresultStatus Returns the result status of the query. PQresultStatus can
return one of the following values:
PGRES_EMPTY_QUERY,
PGRES_COMMAND_OK, /* the query was a command returning no data */
PGRES_TUPLES_OK, /* the query successfully returned tuples */
PGRES_COPY_OUT, /* Copy Out (from server) data transfer started */
PGRES_COPY_IN, /* Copy In (to server) data transfer started */
PGRES_BAD_RESPONSE, /* an unexpected response was received */
PGRES_NONFATAL_ERROR,
PGRES_FATAL_ERROR
If the result status is PGRES_TUPLES_OK, then the routines described below
can be used to retrieve the tuples returned by the query.
Note that a SELECT that happens to retrieve zero tuples still shows
PGRES_TUPLES_OK. PGRES_COMMAND_OK is for commands that can never return
tuples.
-----Original Message-----
From: pgsql-general-owner@hub.org [mailto:pgsql-general-owner@hub.org]On
Behalf Of Daniel Betaille
Sent: Thursday, August 03, 2000 11:42 AM
To: psgsql-general
Subject: [GENERAL] Documentation
Hello,
I'm a new user of postgresql, I've wrote a program in C to insert data
from files.
I'm searching meanings of PQresultStatus but don't find any answers in
the docs I've read.
Where to find that meanings and different values?
Thanks
Daniel