Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id A858CF765A
	for <pgsql-sql@postgresql.org>; Wed, 11 Apr 2012 18:01:39 -0300 (ADT)
Received: from sam.nabble.com ([216.139.236.26])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <cesar.cast.more@gmail.com>) id 1SI4fa-0007F3-PV
	for pgsql-sql@postgresql.org; Wed, 11 Apr 2012 21:01:39 +0000
Received: from [192.168.236.26] (helo=sam.nabble.com)
	by sam.nabble.com with esmtp (Exim 4.72)
	(envelope-from <cesar.cast.more@gmail.com>) id 1SI4fN-0004NR-FZ
	for pgsql-sql@postgresql.org; Wed, 11 Apr 2012 14:01:25 -0700
Date: Wed, 11 Apr 2012 14:01:25 -0700 (PDT)
From: cesar_cast <cesar.cast.more@gmail.com>
To: pgsql-sql@postgresql.org
Message-ID: <1334178085476-5634039.post@n5.nabble.com>
Subject: ERROR:  operator does not exist: integer = integer[]
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: 0.0 (/)
X-Archive-Number: 201204/30
X-Sequence-Number: 36507

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.