Tom Lane escreveu: > Euler Taveira de Oliveira <[EMAIL PROTECTED]> writes: >> 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[] > > It's entirely right: there's no such operator. > Out of curiosity, why the other queries work?
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) -- 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