Re: libpq confusion

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