operator does not exist: smallint <> smallint[]
От | Euler Taveira de Oliveira |
---|---|
Тема | operator does not exist: smallint <> smallint[] |
Дата | |
Msg-id | 493DF489.7060609@timbira.com обсуждение исходный текст |
Ответы |
Re: operator does not exist: smallint <> smallint[]
|
Список | pgsql-hackers |
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/
В списке pgsql-hackers по дате отправления: