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
Carlos Mennens wrote:
> I'm trying to update a customer record in a table however I need to
> change several values (cust_address, cust_contact, cust_email). My
> question is how do I properly format this into one single command?
>
>
> forza=# SELECT cust_id, cust_name, cust_address, cust_contact
