ERROR: operator does not exist: integer = integer[] - Mailing list pgsql-bugs

From cesar_cast
Subject ERROR: operator does not exist: integer = integer[]
Date
Msg-id 1334179068706-5634075.post@n5.nabble.com
Whole thread Raw
Responses Re: ERROR: operator does not exist: integer = integer[]  (Ashesh Vashi <ashesh.vashi@enterprisedb.com>)
List 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 by date:

Previous
From: Keith Fiske
Date:
Subject: Re: BUG #6581: pg_dumpall --no-tablespaces option still sets default tablespace
Next
From: Ashesh Vashi
Date:
Subject: Re: ERROR: operator does not exist: integer = integer[]