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 <[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 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).
> >
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
