Re: [BUGS] ERROR: operator does not exist: integer = integer[]

On Thu, Apr 12, 2012 at 2:47 AM, cesar_cast wrote: > I have the following > > select * > from employee AS e > where (e.id) IN (ARRAY[3,1]); > Use: SELECT * FROM employee AS e WHERE e.id = ANY(ARRAY[3,1]); -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company

[BUGS] ERROR: operator does not exist: integer = integer[]

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