How to pass array of values to a stored procedure - Mailing list pgsql-sql

From Curtis Scheer
Subject How to pass array of values to a stored procedure
Date
Msg-id 031936836C46D611BB1B00508BE7345D048DAAB8@gatekeeper.daycos.com
Whole thread Raw
Responses Re: How to pass array of values to a stored procedure  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: How to pass array of values to a stored procedure  ("Tony Wasson" <ajwasson@gmail.com>)
List pgsql-sql
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Does anyone have any examples of how I would make a stored procedure in plpgsql that would allow for
passinga list or arrays of values to be used in an sql </span></font>IN clause?  Like so: select * from table where
field1in (values).<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 
12.0pt"> </span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:
12.0pt">Thanks,</span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:
12.0pt"> </span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:
12.0pt">Curtis</span></font><font face="Arial" size="2"><span style="font-size:
10.0pt;font-family:Arial"></span></font></div>

pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: hi let me know the solution to this question
Next
From: "Aaron Bono"
Date:
Subject: Re: hi let me know the solution to this question