StOo <stuart(at)comodo(dot)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