On Thu, 17 Oct 2002, Cool Screen wrote:
> 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()?
Not really, but you may want to look at contrib/array
for some functions/operators that do item in array
lookups.