Argument type list

From: "Gustavo Tonini" <gustavotonini(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Argument type list
Date: 2007-08-23 16:56:40
Message-ID: 9c31dd0d0708230956t7ae067ebv9b958754a87e0f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ???) RETURNS VOID AS
$body$
BEGIN
select * from foo where foo_column in list;
END;
$body$
LANGUAGE 'plpgsql' ;

I played with arrays but I got no success...
Is it possible? How proceed?

Thanks,
Gustavo.

PS: Please C.C. to me, I'm not subscribed in list.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2007-08-23 17:00:09 Re: PostgreSQL vs Firebird feature comparison finished
Previous Message Tony Caduto 2007-08-23 16:52:48 Re: PostgreSQL vs Firebird feature comparison finished