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

#1

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 <cesar.cast.more (AT) gmail (DOT) com>:

Quote:

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 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....9p5634039.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

--
Sent via pgsql-sql mailing list (pgsql-sql (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

--
Sent via pgsql-sql mailing list (pgsql-sql (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

mailing.database.pgsql-sql mailing.database.pgsql-sql

Re: [SQL] ERROR: operator does not exist: integer = integer[] - 04-16-2012 , 09:30 AM