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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org