On Wed, 22 Oct 2008 14:46:35 +0200
Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote:
> 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
Hi,
http://www.postgresql.org/docs/current/static/arrays.html
# SELECT 1 = ANY ('{1,2,3}'::integer[]);
?column?
--
t
Ludo
On Wed, Oct 22, 2008 at 2:46 PM, Ivan Sergio Borgonovo
<[EMAIL PROTECTED]> wrote:
> Without building up a dynamic query is it possible to:
>
> create or replace fu
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
--
Sent via pgsql-general mailing list (pg
