Skip site navigation (1) Skip section navigation (2)

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

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: cesar_cast <cesar(dot)cast(dot)more(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: ERROR: operator does not exist: integer = integer[]
Date: 2012-04-16 14:30:32
Message-ID: CAFj8pRBJH1AtYtpwSrXvJsz7VgLr1nZW98cfZQevrhTtD6C0-w@mail.gmail.com (view raw or flat)
Thread:
Lists: 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(dot)cast(dot)more(at)gmail(dot)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-tp5634039p5634039.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

In response to

pgsql-sql by date

Next:From: DennisDate: 2012-04-18 10:11:54
Subject: Uniform UPDATE queries
Previous:From: Jasen BettsDate: 2012-04-12 12:26:18
Subject: Re: How to html-decode a html-encoded field

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group