X-Original-To: pgsql-sql@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id F30A4925B2B for ; Mon, 2 Jun 2003 09:36:28 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 88986-01 for ; Mon, 2 Jun 2003 09:36:18 -0400 (EDT) Received: from shop.sme.sk (episoftware.casablanca.sk [217.11.230.150]) by developer.postgresql.org (Postfix) with ESMTP id 5B0CD925202 for ; Mon, 2 Jun 2003 09:36:18 -0400 (EDT) Received: from [193.58.192.97] (helo=juice) by shop.sme.sk with esmtp (Exim 3.35 #1 (Debian)) id 19MpQQ-0002Df-00 for ; Mon, 02 Jun 2003 15:32:34 +0200 Received: from 192.168.1.25 ([192.168.1.25]) by juice for pgsql-sql@postgresql.org; Mon, 2 Jun 2003 15:35:15 +0200 Subject: Using & - operator From: Rado Petrik To: pgsql-sql@postgresql.org Content-Type: text/plain Organization: Message-Id: <1054560854.622.14.camel@caj> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.3 Date: 02 Jun 2003 15:34:15 +0200 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new X-Archive-Number: 200306/16 X-Sequence-Number: 13774 Hi, I have table users; id name bin -------------- 1 xx 9 dec(1) & dec(9) = dec(1) bin(0001) & bin(1001) = bin(0001) This query is bad. SELECT name FROM users WHERE id_user=1 AND (bin & 1) This query return "Warning: PostgreSQL query failed: ERROR: right- hand side of AND is type 'integer', not 'boolean' in" Wow I write corect this query ? Thanks. -- Rado Petrik