How to pass array of values to a stored procedure

From: Curtis Scheer <Curtis(at)DAYCOS(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to pass array of values to a stored procedure
Date: 2006-07-18 14:26:30
Message-ID: 031936836C46D611BB1B00508BE7345D048DAAB8@gatekeeper.daycos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Aaron Bono 2006-07-18 15:54:12 Re: hi let me know the solution to this question
Previous Message Michael Fuhr 2006-07-18 05:34:42 Re: hi let me know the solution to this question