X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id B452D3120FD for ; Tue, 10 Jun 2003 05:34:56 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 31658-08 for ; Tue, 10 Jun 2003 02:34:46 -0300 (ADT) Received: from shop.sme.sk (episoftware.casablanca.sk [217.11.230.150]) by svr1.postgresql.org (Postfix) with ESMTP id DB57E30FE4F for ; Mon, 9 Jun 2003 09:31:14 +0000 (GMT) Received: from [193.58.192.97] (helo=juice) by shop.sme.sk with esmtp (Exim 3.35 #1 (Debian)) id 19PIuH-0002cB-00 for ; Mon, 09 Jun 2003 11:25:37 +0200 Received: from 192.168.1.25 ([192.168.1.25]) by juice for pgsql-sql@postgresql.org; Mon, 9 Jun 2003 11:26:11 +0200 Subject: Retype From: Rado Petrik To: pgsql-sql@postgresql.org Content-Type: text/plain Organization: Message-Id: <1055150663.1819.9.camel@caj> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.3 Date: 09 Jun 2003 11:24:24 +0200 Content-Transfer-Encoding: 7bit X-Archive-Number: 200306/74 X-Sequence-Number: 13832 Hi, I have query " SELECT id_user FROM user WHERE (freg_u & 2 ) > 0 ". freg_u is type smallint. Query return this error. PostgreSQL query failed: ERROR: Unable to identify an operator '&' for types 'smallint' and 'integer' You will have to retype this query using an explicit cast in How I retype freg_u to interger ? -- Rado Petrik