Re: PreparedStatement for set membership (The IN operator) - Mailing list pgsql-jdbc

On 05.04.2011 10:17, Daron Ryan wrote:
> Hello,
>
> I need to use a SELECT statement with varying data for set membership. IE.
>
> SELECT link_id
> FROM links
> WHERE heading_id IN (?, ?, ?)
>
> It won't always be the same number of members in the set. I am using an
> ordinary statement with an executeQuery call but would prefer to use a
> PreparedStatement. Is this possible? If so how do I set the values in
> the set?

You can do "WHERE heading_id = ANY (?)", and pass an array of the ids
for the parameter.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com