Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 1CD329F9B35 for ; Mon, 17 Sep 2007 11:30:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 59457-03 for ; Mon, 17 Sep 2007 11:30:38 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id 10A649F9ADE for ; Mon, 17 Sep 2007 11:30:46 -0300 (ADT) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Mon, 17 Sep 2007 09:30:45 -0500 Message-Id: <46EE4931.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.2 Date: Mon, 17 Sep 2007 09:30:26 -0500 From: "Kevin Grittner" To: "Tom Lane" Cc: "valgog" , Subject: Re: Index usage when bitwise operator is used References: <46ED7CCD.EE98.0025.0@wicourts.gov> <1190015368.148293.56830@y42g2000hsy.googlegroups.com> <46EE2C53.EE98.0025.0@wicourts.gov><46EE2C53.EE98.0025.0@wicourts.gov> <21403.1190036229@sss.pgh.pa.us> In-Reply-To: <21403.1190036229@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/294 X-Sequence-Number: 26839 >>> On Mon, Sep 17, 2007 at 8:37 AM, in message <21403.1190036229@sss.pgh.= pa.us>, Tom Lane wrote:=20 > "Kevin Grittner" writes: >> On Mon, Sep 17, 2007 at 2:49 AM, in message >> <1190015368.148293.56830@y42g2000hsy.googlegroups.com>, valgog >> wrote:=3D20 >>> Are you sure you understood what was the question? >>>=20 >>> Is the TBL1.CATEGORY =3D TBL2.CATEGORY the same as TBL1.CATEGORY & >>> TBL2.CATEGORY > 0? >=20 >> Yes, given that he stipulated that one and only one bit would be set. >=20 > Really? In that case, isn't this bit-field just a bad implementation of > an enum-style field? =20 My bad. I did misread it. Sorry, all. =20 -Kevin =20