Re: Array in nested query

Поиск
Список
Период
Сортировка
Искать
От
Fernando Moreno
Тема
Re: Array in nested query
Дата
Msg-id
b1c45530902142105l6491045o9c0a15c8c888c38b@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Array in nested query "Ken Winter" <ken@sunward.org>
Re: Array in nested query Gerhard Heift <ml-postgresql-20081012-3518@gheift.de>
Re: Array in nested query Fernando Moreno <azazel.7@gmail.com>
Re: Array in nested query Osvaldo Kussama <osvaldo.kussama@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.

Cheers.
В списке pgsql-general по дате отправления
От: John R Pierce
Дата:
Сообщение: Re: pg_hba reload
От: Sim Zacks
Дата:
Сообщение: Re: password for postgres
FAQ