Hello
this is not error, you cannot use predicate IN in this context
use =ANY instead
postgres=> select 10 = ANY(ARRAY[1,2,3]);
?column?
--
f
(1 row)
postgres=> select 10 = ANY(ARRAY[1,2,3,10]);
?column?
--
t
(1 row)
Regards
Pavel Stehule
2012/4/11 cesar_cast :
> I have
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
