On Wed, Jan 10, 2007 at 04:34:00PM +0100, riki wrote: > Hi, > > i'm trying to extract some info from system catalog tables. > documentation says that i should join columns of different data type. > that is int2[] with int2, array with integer. > how can i make this join work?
You can use the ANY() operator for this: # select 1 = ANY( ARRAY[2,3,4] ); ?column? ---------- f (1 row) # select 2 = ANY( ARRAY[2,3,4] ); ?column? ---------- t (1 row) Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature
