Re: prepared statements - Mailing list pgsql-sql

From Pavel Stehule
Subject Re: prepared statements
Date
Msg-id CAFj8pRC2K3-1UfsvQ6ZQ3HjqxKoC6X_gsv-dDqBy3s2P1EJdVA@mail.gmail.com
Whole thread Raw
In response to prepared statements  (Vad N <vadimid@gmail.com>)
Responses Re: prepared statements
List pgsql-sql
Hello

2011/12/8 Vad N <vadimid@gmail.com>:
>
> Hi.
>
> How can i pass a set of values to prepared statement?
>
> example
> I have a prepared query:
> select * from users in ( $1 )
>
> i would like to pass: 1,2,3,4 and get:
>
> select * from users in ( 1,2,3,4 )
>
> Any ideas?

use a array parameter, please

regards

Pavel Stehule


pgsql-sql by date:

Previous
From: Andreas
Date:
Subject: Question on imports with foreign keys
Next
From: "Emre Hasegeli"
Date:
Subject: Re: Question on imports with foreign keys