Re: ANY subquery and PreparedStatements

I agree, and you can find it in lots of languages... even Visual
Basic.
  Anyway, wouldn't help my problem, unfortunately :-)))

On Wed, 2003-02-19 at 11:57, Jason S. Friedman wrote:
> My two cents:  it would be great if Java had a built-in (JDK) method that did the same thing as the Perl join
command:
>
> @array = ( 'apple', 'banana', 'orange' );
> $fruit = join( ',', @array );
> # result is 'apple,banana,orange'
>
> On Wed, Feb 19, 2003 at 09:56:47AM -0300, Felipe Schnack wrote:
> >   Yes, this would work... but it's not very pretty :-)
> >   JDBC's preparedstatements should have *some way* to handle that...
> > simply makeing impossible to use such an useful keyword is quite bad...
> >   Or jdbc doesnt have it?
> >
> > On Wed, 2003-02-19 at 09:49, Pavel Fokin wrote:
> > > Felipe Schnack wrote:
> > >
> > > >  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?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--

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

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