2009/2/15 Fernando Moreno <azaze...@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. >
Look this thread: http://archives.postgresql.org/pgsql-hackers/2008-12/msg00496.php Osvaldo -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general