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

Поиск
Список
Период
Сортировка
От cesar_cast
Тема ERROR: operator does not exist: integer = integer[]
Дата
Msg-id 1334178085476-5634039.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: ERROR: operator does not exist: integer = integer[]  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-sql
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-tp5634039p5634039.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.


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

Предыдущее
От: lewbloch@gmail.com
Дата:
Сообщение: Re: UPDATE Multiple Records At Once?
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: ERROR: operator does not exist: integer = integer[]