Re: libpq confusion

[John R Pierce <pierce@xxxxxxxxxxxx>]

On 9/20/2017 6:30 AM, Igor Korot wrote:

Hi, guys,

On Wed, Sep 20, 2017 at 12:20 AM, Allan Harvey
<allan.harvey@xxxxxxxxxxxxxxxxxxx> wrote:

How do I properly check if the record exists from libpq?

Igor,
I use PQntuples() to check the number of ... tuples, for > 0

I was actually curious - isn't it what "PGRES_COMMAND_OK" for?
IIUC, this constant indicates successful query run, but no records was
generated.

Or am I missing something and I will have to check PQntuples()?

a query that returns zero rows is still successful.

-- 
john r pierce, recycling bits in santa cruz