From: | cesar_cast <cesar(dot)cast(dot)more(at)gmail(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | ERROR: operator does not exist: integer = integer[] |
Date: | 2012-04-11 21:01:25 |
Message-ID: | 1334178085476-5634039.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Jasen Betts | 2012-04-12 12:26:18 | Re: How to html-decode a html-encoded field |
Previous Message | Thomas Kellerer | 2012-04-11 20:55:08 | Re: UPDATE Multiple Records At Once? |