Re: Array in nested query
От
Fernando Moreno
Тема
Re: Array in nested query
Дата
Msg-id
b1c45530902142105l6491045o9c0a15c8c888c38b@mail.gmail.com
Ответ на
Array in nested query (Ken Winter)
Список
Дерево обсуждения
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 по дате отправления