[GENERAL] How to pass array of values to a pgplsql function

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). Is this possible? Thanks, Curtis ---(end of

Re: [GENERAL] How to pass array of values to a pgplsql function

Curtis Scheer wrote: 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). Is this possible? Well, a good thing to note

Re: [GENERAL] How to pass array of values to a pgplsql function

Erik Jones wrote: Curtis Scheer wrote: 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). Is this possible? Well, a

Re: [GENERAL] How to pass array of values to a pgplsql function

Thanks, Erik another possible solution would also be this. Here it is in case you are interested. On 7/18/06, Tony Wasson [EMAIL PROTECTED] wrote: On 7/18/06, Curtis Scheer [EMAIL PROTECTED] wrote: Does anyone have any examples of how I would make a stored procedure in plpgsql that would