pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedERROR: operator does not exist: integer = integer[]
2+ messages / 2 participants
[nested] [flat]
* ERROR: operator does not exist: integer = integer[]
@ 2012-04-11 21:01 cesar_cast <cesar.cast.more@gmail.com>
2012-04-16 14:30 ` Re: ERROR: operator does not exist: integer = integer[] Pavel Stehule <pavel.stehule@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: cesar_cast @ 2012-04-11 21:01 UTC (permalink / raw)
To: pgsql-sql
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.com/ERROR-operator-does-not-exist-integer-integer-tp5634039p5634...
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: ERROR: operator does not exist: integer = integer[]
2012-04-11 21:01 ERROR: operator does not exist: integer = integer[] cesar_cast <cesar.cast.more@gmail.com>
@ 2012-04-16 14:30 ` Pavel Stehule <pavel.stehule@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Pavel Stehule @ 2012-04-16 14:30 UTC (permalink / raw)
To: cesar_cast <cesar.cast.more@gmail.com>; +Cc: pgsql-sql
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@gmail.com>:
> 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.com/ERROR-operator-does-not-exist-integer-integer-tp5634039p5634...
> Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2012-04-16 14:30 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-04-11 21:01 ERROR: operator does not exist: integer = integer[] cesar_cast <cesar.cast.more@gmail.com>
2012-04-16 14:30 ` Re: ERROR: operator does not exist: integer = integer[] Pavel Stehule <pavel.stehule@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox