Re: where column in ARRAY - Mailing list pgsql-general

From Ludovic Levesque
Subject Re: where column in ARRAY
Date
Msg-id 162718d40810220604t49aac5e4l984905b06cbdd981@mail.gmail.com
Whole thread Raw
In response to where column in ARRAY  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List pgsql-general
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
<mail@webthatworks.it> 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?
>
> --
> Ivan Sergio Borgonovo
> http://www.webthatworks.it
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: Shopping cart
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: where column in ARRAY