2017-09-20 5:36 GMT+02:00 Igor Korot <ikoro...@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 >
