libpq Prepared Statement with dynamic IN operator

From: Dave Greeko <davegreeko(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: libpq Prepared Statement with dynamic IN operator
Date: 2020-11-24 19:14:03
Message-ID: 418457940.732204.1606245243551@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear All,
I am having a hard time figuring out how prepare and execute a Prepared Statement with an "IN" operator in the WHERE clause using libpq. The total elements that will be passed to IN operator is dynamic and varied at runtime.
here is an example query:

select payload_id,ptime,frequency from codecs where tag IN (‘G729’,’GSM’);

The number of elements to filter for with this particular example is 2 but this varies at runtime (between 1 to 127 elements).
I would like to know what’s the proper syntax of the (char *query) parameter when calling the PQprepare() function.
I tried “select payload_id,ptime,frequency from codecs where tag=ANY(?)” but failed

Regards,
Dave

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2020-11-24 19:27:49 Re: libpq Prepared Statement with dynamic IN operator
Previous Message Ron 2020-11-24 17:34:42 Re: Performance hit if I create multiple DBs on same instance