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

hi,

try

select unnest(ARRAY[?,?,?])

regards
Thomas


Am 05.04.2011 09:17, schrieb Daron Ryan:
>  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?
>
> Regards,
> Daron.
>