Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] libpq confusion - Mailing list pgsql-general

From Pavel Stehule
Subject Re: [GENERAL] libpq confusion
Date
Msg-id CAFj8pRCco=y_AMz5Pe4+tKic1aCWr=g9oMMC4Va8ZSBmRHOdww@mail.gmail.com
Whole thread Raw
In response to [GENERAL] libpq confusion  (Igor Korot <ikorot01@gmail.com>)
List pgsql-general
Tree view


2017-09-20 5:36 GMT+02:00 Igor Korot <ikorot01@gmail.com>:
Hi, ALL,

draft=# SELECT 1 FROM abcattbl WHERE abt_tnam = 'leagues';
 ?column?
----------
(0 rows)


However running it thru the PQexecParam() I am getting "PGRES_TUPLES_OK"
which means that the such record exist.

That means so this command doesn't fail  - not so there  are some record.

you can use different query, that returns true, false

SELECT EXISTS(SELECT * FROM abcattbl WHERE abt_tnam = 'leagues');

Regards

Pavel


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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: [GENERAL] libpq confusion
Next
From: Allan Harvey
Date:
Subject: Re: [GENERAL] libpq confusion