Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group