ANY subquery and PreparedStatements

From: Felipe Schnack <felipes(at)ritterdosreis(dot)br>
To: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: ANY subquery and PreparedStatements
Date: 2003-02-19 12:24:24
Message-ID: 1045657464.24753.13.camel@desenv1.ritterdosreis.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I'm afraid it kind of impossible to use PreparedStatements with the
"ANY" subquery keyword... For example, if I take this query and prepare
it:
"select * from <table> where <field> any (?)"
How can I set my parameter as a list of values, so my query searches
for for different values of the specified field?

--

Felipe Schnack
Analista de Sistemas
felipes(at)ritterdosreis(dot)br
Cel.: (51)91287530
Linux Counter #281893

Centro Universitário Ritter dos Reis
http://www.ritterdosreis.br
ritter(at)ritterdosreis(dot)br
Fone/Fax.: (51)32303341

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Pavel Fokin 2003-02-19 12:49:08 Re: ANY subquery and PreparedStatements
Previous Message Michał Niklas 2003-02-19 11:00:37 getColumns() is not table name case insensitive