Re: join problem...

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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.