Обсуждение: join problem...

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?

thanks

http://www.postgresql.org/docs/7.4/static/catalog-pg-constraint.html

      conkey int2[] pg_attribute.attnum If a table constraint, list of
columns which the constraint constrains

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.