Erik Jones <erik@myemma.com> writes:
> On Aug 23, 2007, at 11:56 AM, Gustavo Tonini wrote:
>> I want to create a function that receive a list argument and filter
>> data with IN operator. Example:
> CREATE OR REPLACE FUNCTION public.ffoo(list sometype[]) RETURNS VOID
this is right ...
> execute 'select * from foo where foo_column::text in (' ||
> array_to_string(list, ',') || ');';
this is pretty horrid. Use = ANY(array) instead of trying to construct
an IN on the fly.
select * from foo where foo_column = any(list)
regards, tom lane