Re: Arrya variable as argument to IN expression

O Emil Kaffeshop έγραψε στις Nov 17, 2005 :

> Hello I am trying the following:
> a INTEGER[] := ''{10,15,20}'';
> b INTEGER := 15;
> flag BOOLEAN := FALSE;
> 
> SELECT b IN (a) INTO flag; !!! does not work

contrib/intarray and
SELECT intset(b) ~ a::int[] INTO flag;
are your friends.

> 
> Is it legal to expect the array to be interpret as
> list of integers which IN expression takes ?
> 
> Best Regards
> Emil kafegiiski
> 
> 
> 
>         
> __________________________________ 
> Yahoo! FareChase: Search multiple travel sites in one click.
> http://farechase.yahoo.com
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
> 

-- 
-Achilleus