Randall Perry <rgp(at)systame(dot)com> writes:
> I want to make sure queries returned aren't empty.
Check the number of rows returned (after checking for OK
resultStatus).
> But it returns '2' (not sure which constant it is, but it's not
> PGRES_EMPTY_QUERY) on empty queries.
PGRES_EMPTY_QUERY means you sent an empty string as the query, eg
$conn->exec("");
This is pretty useless, and is distinguished only for historical
reasons...
regards, tom lane