Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 14C4A9F9C87 for ; Mon, 17 Sep 2007 04:49:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 30071-02 for ; Mon, 17 Sep 2007 04:49:27 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id E34949F9F1E for ; Mon, 17 Sep 2007 04:49:29 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id E2DB83143A; Mon, 17 Sep 2007 09:49:28 +0200 (MET DST) From: valgog X-Newsgroups: pgsql.performance Subject: Re: Index usage when bitwise operator is used Date: Mon, 17 Sep 2007 07:49:28 -0000 Organization: http://groups.google.com Lines: 11 Message-ID: <1190015368.148293.56830@y42g2000hsy.googlegroups.com> References: <46ED7CCD.EE98.0025.0@wicourts.gov> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Complaints-To: groups-abuse@google.com In-Reply-To: <46ED7CCD.EE98.0025.0@wicourts.gov> User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: y42g2000hsy.googlegroups.com; posting-host=62.220.8.122; posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0 To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.064 tagged_above=0 required=5 tests=AWL=0.063, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200709/285 X-Sequence-Number: 26830 > What about saying?: > > TBL1.CATEGORY = TBL2.CATEGORY > Are you sure you understood what was the question? Is the TBL1.CATEGORY = TBL2.CATEGORY the same as TBL1.CATEGORY & TBL2.CATEGORY > 0?