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[]  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Chernow
Дата:
Сообщение: Re: parallel restore vs. windows
Следующее
От: "Fujii Masao"
Дата:
Сообщение: Re: Multiplexing SUGUSR1