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

From Fernando Moreno
Subject Re: Array in nested query
Date
Msg-id b1c45530902142105l6491045o9c0a15c8c888c38b@mail.gmail.com
Whole thread Raw
In response to Array in nested query  ("Ken Winter" <ken@sunward.org>)
Responses Re: Array in nested query
List pgsql-general
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.

Cheers.

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: pg_hba reload
Next
From: Sim Zacks
Date:
Subject: Re: password for postgres