Received: from localhost (unknown [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 1D1B29F9F2A
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 17 Sep 2007 09:27:36 -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 12061-04 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 17 Sep 2007 09:27:26 -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 1DF509F9F1C
	for <pgsql-performance@postgresql.org>;
	Mon, 17 Sep 2007 09:27:31 -0300 (ADT)
Received: from Courts-MTA by gwmta.wicourts.gov
	with Novell_GroupWise; Mon, 17 Sep 2007 07:27:29 -0500
Message-Id: <46EE2C53.EE98.0025.0@wicourts.gov>
X-Mailer: Novell GroupWise Internet Agent 7.0.2 
Date: Mon, 17 Sep 2007 07:27:15 -0500
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "valgog" <valgog@gmail.com>,<pgsql-performance@postgresql.org>
Subject: Re: Index usage when bitwise operator is used
References: <f97d4e240709130530ve3cc522g61ccca23335618f4@mail.gmail.com>
	<46ED7CCD.EE98.0025.0@wicourts.gov>
	<1190015368.148293.56830@y42g2000hsy.googlegroups.com>
In-Reply-To: <1190015368.148293.56830@y42g2000hsy.googlegroups.com>
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/291
X-Sequence-Number: 26836

>>> On Mon, Sep 17, 2007 at  2:49 AM, in message
<1190015368.148293.56830@y42g2000hsy.googlegroups.com>, valgog
<valgog@gmail.com> wrote:=20

>> What about saying?:
>>
>>   TBL1.CATEGORY =3D TBL2.CATEGORY
>>
>=20
> 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?

Yes, given that he stipulated that one and only one bit would be set.
=20
-Kevin
=20