Re: Array in nested query - Mailing list pgsql-general

From Osvaldo Kussama
Subject Re: Array in nested query
Date
Msg-id 690707f60902150716i215ccd76k202ef9f152f6822e@mail.gmail.com
Whole thread Raw
In response to Re: Array in nested query  (Fernando Moreno <azazel.7@gmail.com>)
List pgsql-general
2009/2/15 Fernando Moreno <azazel.7@gmail.com>:
> What error are you getting?
>
> I tried your query and I had to add an explicit cast to smallint[] to
> make it work. Like this:
>
> ... a.attnum = any ((select conkey FROM pg_catalog.pg_constraint WHERE
>> oid = 3708025)::smallint[]);
>
> It seems strange to me, I didn't expect the ANY clause to need that
> cast. Or maybe I'm missing something.
>


Look this thread:
http://archives.postgresql.org/pgsql-hackers/2008-12/msg00496.php

Osvaldo

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: currval() in insert statements
Next
From: Scott Marlowe
Date:
Subject: Re: How do I set the schema search path in a datasource config for a connection pool?