On 9/20/2017 10:34 AM, Igor Korot wrote:
>From the documentation:
https://www.postgresql.org/docs/9.1/static/libpq-exec.html
[quote]
PGRES_COMMAND_OK
Successful completion of a command returning no data.
[/quote]
No data = no rows, right?
from that same page, a bit farther down, clarifying the potentially
confusing wording.
If the result status isPGRES_TUPLES_OK, then the functions described
below can be used to retrieve the rows returned by the query. Note
that aSELECTcommand that happens to retrieve zero rows still
showsPGRES_TUPLES_OK.PGRES_COMMAND_OKis for commands that can never
return rows (INSERT,UPDATE, etc.). A response
ofPGRES_EMPTY_QUERYmight indicate a bug in the client software.
--
john r pierce, recycling bits in santa cruz
