Tom Lane escreveu:
> Euler Taveira de Oliveira <euler@timbira.com> 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/
