| From: | Osvaldo Kussama <osvaldo(dot)kussama(at)gmail(dot)com> |
|---|---|
| To: | Fernando Moreno <azazel(dot)7(at)gmail(dot)com> |
| Cc: | Ken Winter <ken(at)sunward(dot)org>, PostgreSQL pg-general List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Array in nested query |
| Date: | 2009-02-15 15:16:31 |
| Message-ID: | 690707f60902150716i215ccd76k202ef9f152f6822e@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2009/2/15 Fernando Moreno <azazel(dot)7(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2009-02-15 15:47:36 | Re: How do I set the schema search path in a datasource config for a connection pool? |
| Previous Message | Craig Ringer | 2009-02-15 14:06:28 | Re: currval() in insert statements |