Re: [INTERFACES] eekk tuples ok when there not! - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: [INTERFACES] eekk tuples ok when there not!
Date
Msg-id 14994.935166832@sss.pgh.pa.us
Whole thread Raw
In response to eekk tuples ok when there not!  (StOo <stuart@comodo.net>)
List pgsql-interfaces
StOo <stuart@comodo.net> writes:
> after calling PgConnection::Exec(const char *query);
> it returns PGRES_TUPLES_OK even when there is nothing in the table!

Yes.  Always has, always will.  PGRES_TUPLES_OK means you did a
SELECT and had no error --- it is not an error for the SELECT
to find no matching tuples.  You have to look at PQntuples
to find out how many tuples you got back.
        regards, tom lane


pgsql-interfaces by date:

Previous
From: "Ken J. Wright"
Date:
Subject: Re: [INTERFACES] eekk tuples ok when there not!
Next
From: Yu Cao
Date:
Subject: Re: [INTERFACES] libpq++ ---- PgDatabase instance problem