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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
