Re: Argument type list

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