where column in ARRAY - Mailing list pgsql-general

From Ivan Sergio Borgonovo
Subject where column in ARRAY
Date
Msg-id 20081022144635.55120274@dawn.webthatworks.it
Whole thread Raw
Responses Re: where column in ARRAY  ("Ludovic Levesque" <luddic@gmail.com>)
Re: where column in ARRAY  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List pgsql-general
Without building up a dynamic query is it possible to:

create or replace function t1(a int[]) as
$$
...
select * from t1 where c in a; // eg in spite of in (1,2,3);

or just obtain a similar effect?

--
Ivan Sergio Borgonovo
http://www.webthatworks.it


pgsql-general by date:

Previous
From: "Grzegorz Jaśkiewicz"
Date:
Subject: Re: Shopping cart
Next
From: Teodor Sigaev
Date:
Subject: Re: index scan leads to result that is different from sec scan after upgrading to 8.3.4