Re: Array in nested query

From: Fernando Moreno <azazel(dot)7(at)gmail(dot)com>
To: Ken Winter <ken(at)sunward(dot)org>
Cc: PostgreSQL pg-general List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Array in nested query
Date: 2009-02-15 05:05:32
Message-ID: b1c45530902142105l6491045o9c0a15c8c888c38b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sim Zacks 2009-02-15 06:07:32 Re: password for postgres
Previous Message Greg Smith 2009-02-15 02:49:43 Re: clearing the buffer cache