On Thu, Apr 12, 2012 at 2:47 AM, cesar_cast <cesar.cast.m...@gmail.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs >
