DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:From:To:Cc:References:In-Reply-To:Subject:Date:Message-ID:MIME-Version:Content-Type:Content-Transfer-Encoding:X-Mailer:Thread-Index:Content-Language;
	b=rEcba2RAm0/lSMfQvRFbicu9U8yrBAsPb1Blb5F3ERXRGItoBGzGNQHn0m9ic4kbrGJhEBCP9iarSDWQfvVtrqq8EPEk+hNDTQHi1+Tn9iOoZXPPmmNEMadAOCFmf+MAx9+5U6cwfylwCttjdi80l2hNcUHrbVmT4LDQ3s4mt5Q=
	;
From: "David Johnston" <polobo@yahoo.com>
To: "'Pavel Stehule'" <pavel.stehule@gmail.com>, "'Vad N'" <vadimid@gmail.com>
Cc: <pgsql-sql@postgresql.org>
References: 
 <CAPuKw9Rp=z=o1GO8fdBJbedjHOc8p-CTYeuV8O9Fz+yWVWNUjQ@mail.gmail.com>
	<CAFj8pRC2K3-1UfsvQ6ZQ3HjqxKoC6X_gsv-dDqBy3s2P1EJdVA@mail.gmail.com>
In-Reply-To: 
 <CAFj8pRC2K3-1UfsvQ6ZQ3HjqxKoC6X_gsv-dDqBy3s2P1EJdVA@mail.gmail.com>
Subject: Re: prepared statements
Date: Thu, 8 Dec 2011 09:42:58 -0500
Message-ID: <050101ccb5b7$aeb96510$0c2c2f30$@yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Thread-Index: AQKWT+MZ78o/jF6TzHn3aqGYA9pqQQIeL40blC3c+3A=
Content-Language: en-us

-----Original Message-----
From: pgsql-sql-owner@postgresql.org =
[mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Pavel Stehule
Sent: Thursday, December 08, 2011 2:40 AM
To: Vad N
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] prepared statements

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

------------------------------------------------------------------

Or, in lieu of readily passing arrays from your client API you can =
always pass a string and modify the query to parse the string into an =
array.

... users =3D ANY ( regexp_split_to_array( $1, ',' )::integer[] )

David J.