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

From Curtis Scheer
Subject Re: How to pass array of values to a stored procedure
Date
Msg-id 031936836C46D611BB1B00508BE7345D048DABB8@gatekeeper.daycos.com
Whole thread Raw
In response to How to pass array of values to a stored procedure  (Curtis Scheer <Curtis@DAYCOS.com>)
List pgsql-sql
Thanks Tom and Tony for the help, I actually implemented the solution using
a bpchar[] and hopefully the "field1 = ANY (arrayvalue)" syntax will not
hurt the query performance a lot without an index scan. 

Thanks again,
Curtis

On 7/18/06, Tony Wasson <ajwasson@gmail.com> wrote:
> On 7/18/06, Curtis Scheer <Curtis@daycos.com> 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).
> >


pgsql-sql by date:

Previous
From: "Aaron Bono"
Date:
Subject: Re: hi let me know the solution to this question
Next
From: Osvaldo Kussama
Date:
Subject: Re: Like with special character