Passing an array to a PL/pgSQL function, is it
possible to implode it and use with IN (...) ? For
example:
my_func(int[])
ids := implode_func($1);
select *
from x
where id in (ids);
I tried concatenating ids together with ',', but the
query gives an integer/text cast error. Or, is it
possible use arrays in IN()?
select *
from x
where id in ({1,2,3});
__________________________________________________
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com
