Using SELECT IN with prepared statement

From: Tiago Alves <talves(at)tapestry(dot)pt>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Using SELECT IN with prepared statement
Date: 2008-11-11 00:06:34
Message-ID: 4918CC8A.9030202@tapestry.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2008-11-11 00:31:42 Re: Pgsql jdbc driver 8.3 Build 603: Commit deadlock
Previous Message Oliver Jowett 2008-11-10 22:54:11 Re: Pgsql jdbc driver 8.3 Build 603: Commit deadlock