ERROR: operator does not exist: integer = integer[]

Поиск
Список
Период
Сортировка
От cesar_cast
Тема ERROR: operator does not exist: integer = integer[]
Дата
Msg-id 1334179068706-5634075.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: ERROR: operator does not exist: integer = integer[]  (Ashesh Vashi <ashesh.vashi@enterprisedb.com>)
Список pgsql-bugs
I have the following

select *
from   employee AS e
where  (e.id) IN  (ARRAY[3,1]);

I have the following mistake
ERROR:  operator does not exist: integer = integer[]
LINE 3: where  (e.id) IN  (ARRAY[3,1]);
                      ^
HINT:  No operator matches the given name and argument type(s). You might
need to add explicit type casts.

********** Error **********

ERROR: operator does not exist: integer = integer[]
SQL state: 42883
Hint: No operator matches the given name and argument type(s). You might
need to add explicit type casts.
Character: 45


Can anybody explain me?

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/ERROR-operator-does-not-exist-integer-integer-tp5634075p5634075.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Keith Fiske
Дата:
Сообщение: Re: BUG #6581: pg_dumpall --no-tablespaces option still sets default tablespace
Следующее
От: Ashesh Vashi
Дата:
Сообщение: Re: ERROR: operator does not exist: integer = integer[]