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

On Thu, Apr 12, 2012 at 2:47 AM, cesar_cast <cesar(dot)cast(dot)more(at)gmail(dot)com>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<http://www.enterprisedb.com/>

*http://www.linkedin.com/in/asheshvashi*

>
> 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.
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>