Re: Using SELECT IN with prepared statement - Mailing list pgsql-jdbc

Hi,

You need to write: select * from users where userid = ANY ?

See
http://www.postgresql.org/docs/8.3/interactive/functions-comparisons.html

Tiago Alves wrote:
> Greetings!
>
> Sorry if you answer this before, I couldn't find it.
>
> I want to do something like:
>
> PreparedStatement ps = connection.prepareStatement("select * from
> users where userid in ?");
> ps.setSomething(anIntArray);
>
> Is this possible? How?
>
> Thanks.
> Tiago A.
>