From: | cesar_cast <cesar(dot)cast(dot)more(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | ERROR: operator does not exist: integer = integer[] |
Date: | 2012-04-11 21:17:48 |
Message-ID: | 1334179068706-5634075.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Ashesh Vashi | 2012-04-12 05:13:02 | Re: ERROR: operator does not exist: integer = integer[] |
Previous Message | Keith Fiske | 2012-04-11 18:29:28 | Re: BUG #6581: pg_dumpall --no-tablespaces option still sets default tablespace |