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@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
