Hi, I saw a report at .br mailing list [1] complaining about the message's title. I do not try to investigate it. Am I missing something?
euler=# select attname from pg_attribute where attnum > 0 and attnum <> ALL(select conkey from pg_constraint where conrelid = attrelid and contype = 'p'); ERROR: operator does not exist: smallint <> smallint[] LINHA 1: ...ame from pg_attribute where attnum > 0 and attnum <> ALL(sel... ^ DICA: No operator matches the given name and argument type(s). You might need to add explicit type casts. euler=# select 1::smallint <> ALL(array[2::smallint, 3::smallint]); ?column? ---------- t (1 registro) euler=# select 1::smallint <> ALL(array[1::smallint, 2::smallint,3::smallint]); ?column? ---------- f (1 registro) euler=# select 1::smallint <> ALL(array[1, 2, 3]); ?column? ---------- f (1 registro) [1] http://listas.postgresql.org.br/pipermail/pgbr-geral/2008-December/013277.html -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers