Emil Kaffeshop <[EMAIL PROTECTED]> writes:
> SELECT b IN (a) INTO flag; !!! does not work
> Is it legal to expect the array to be interpret as
> list of integers which IN expression takes ?
No. But try "b = any (a)".
regards, tom lane
---(end of
am 17.11.2005, um 0:28:51 -0800 mailte Emil Kaffeshop folgendes:
> 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
Sorry, i can't understand your query.
Perhaps you are searchfing for
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 l
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
Is it legal to expect the array to be interpret as
list of integers which IN expression takes ?
Best Regards
Emil kafegiiski
__
