Thanks, Osvaldo and Fernando - your solution works!
> -Original Message-
> From: Osvaldo Kussama [mailto:osvaldo.kuss...@gmail.com]
> Sent: Saturday, February 14, 2009 8:24 PM
> To: Ken Winter
> Subject: Re: [GENERAL] Array in nested query
>
> 2009/2/14 Ken Winte
2009/2/15 Fernando Moreno :
> 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 did
On Sat, Feb 14, 2009 at 05:36:11PM -0500, Ken Winter wrote:
>I'm trying to look up the columns in a constraint in pg_catalog (of
>PostgreSQL 8.0.x). I can't figure out how to "join" the elements of the
>array that lists the `attnum's of the columns in the table to the `conkey'
>arr
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
cas
I'm trying to look up the columns in a constraint in pg_catalog (of
PostgreSQL 8.0.x). I can't figure out how to "join" the elements of the
array that lists the 'attnum's of the columns in the table to the 'conkey'
array in the constraint definition (see
http://www.postgresql.org/docs/8.0/static/c
