2009/2/15 Fernando Moreno <azazel.7@xxxxxxxxx>: > 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
