Re: prepared statements

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Vad N <vadimid(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: prepared statements
Date: 2011-12-08 07:40:04
Message-ID: CAFj8pRC2K3-1UfsvQ6ZQ3HjqxKoC6X_gsv-dDqBy3s2P1EJdVA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello

2011/12/8 Vad N <vadimid(at)gmail(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Emre Hasegeli 2011-12-08 08:39:49 Re: Question on imports with foreign keys
Previous Message Andreas 2011-12-08 06:48:51 Question on imports with foreign keys