2017-09-20 5:36 GMT+02:00 Igor Korot <ikorot01@xxxxxxxxx>:
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
