X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7A5B29FB2CB for ; Tue, 18 Jul 2006 13:26:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 48638-01-4 for ; Tue, 18 Jul 2006 13:26:01 -0300 (ADT) X-Greylist: delayed 00:15:24.446121 by SQLgrey- Received: from gatekeeper.daycos.com (outbound.daycos.com [204.26.70.70]) by postgresql.org (Postfix) with ESMTP id C58779FB3E3 for ; Tue, 18 Jul 2006 11:42:45 -0300 (ADT) Received: by gatekeeper.daycos.com with Internet Mail Service (5.5.2653.19) id ; Tue, 18 Jul 2006 09:26:34 -0500 Message-ID: <031936836C46D611BB1B00508BE7345D048DAAB8@gatekeeper.daycos.com> From: Curtis Scheer To: pgsql-sql@postgresql.org Subject: How to pass array of values to a stored procedure Date: Tue, 18 Jul 2006 09:26:30 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C6AA76.292CE9F0" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=BAYES_50, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200607/229 X-Sequence-Number: 25803 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C6AA76.292CE9F0 Content-Type: text/plain Does anyone have any examples of how I would make a stored procedure in plpgsql that would allow for passing a list or arrays of values to be used in an sql IN clause? Like so: select * from table where field1 in (values). Thanks, Curtis ------_=_NextPart_001_01C6AA76.292CE9F0 Content-Type: text/html Content-Transfer-Encoding: quoted-printable

Does anyone have any examples of how I would make a = stored procedure in plpgsql that would allow for passing a list or arrays of = values to be used in an sql IN clause?  Like so: select * from = table where field1 in (values).

 

Thanks,

 

Curtis

------_=_NextPart_001_01C6AA76.292CE9F0--