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 8DBF030FB4A for ; Mon, 30 Jun 2003 12:37:17 +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 79666-07 for ; Mon, 30 Jun 2003 09:37:07 -0300 (ADT) Received: from boa.eo.pl (boa.eo.pl [217.17.46.250]) by svr1.postgresql.org (Postfix) with SMTP id 0760D30F4CA for ; Mon, 30 Jun 2003 09:37:06 -0300 (ADT) Received: (qmail 30190 invoked from network); 30 Jun 2003 12:37:01 -0000 Received: from unknown (HELO depeszws) (depesz@eo.pl@62.233.139.194) by boa.eo.pl with SMTP; 30 Jun 2003 12:37:01 -0000 Date: Mon, 30 Jun 2003 14:36:31 +0200 From: Hubert Lubaczewski To: "Rudi Starcevic" Cc: pgsql-sql@postgresql.org Subject: Re: Bitwise operation Message-Id: <20030630143631.794015db.hubert.lubaczewski@eo.pl> In-Reply-To: <20030630122815.M76087@oasis.net.au> References: <20030630122815.M76087@oasis.net.au> Organization: EO Networks X-Mailer: Sylpheed version 0.8.11claws161 (GTK+ 1.2.10; i386-debian-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Archive-Number: 200306/335 X-Sequence-Number: 14093 On Mon, 30 Jun 2003 22:28:15 +1000 "Rudi Starcevic" wrote: > SELECT 1111 & 111 = 71 > I was expecting the second example to be > SELECT 1111 & 111 = 111 hmm ..: let's see: dec(1111) is bin(10001010111) dec(111) is bin(00001101111) so, when we'll "AND" them: 1111 : 10001010111 111 : 00001101111 ------------------- 00001000111 : dec: 71 quite reasonable, isn't it? depesz