View Single Post

   
  #7 (permalink)  
Old 04-19-2008, 10:34 AM
Kevin Grittner
 
Posts: n/a
Default Re: Index usage when bitwise operator is used

>>> On Mon, Sep 17, 2007 at 8:37 AM, in message <21403.1190036229@sss.pgh.pa.us>,
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
>> On Mon, Sep 17, 2007 at 2:49 AM, in message
>> <1190015368.148293.56830@y42g2000hsy.googlegroups. com>, valgog
>> <valgog@gmail.com> wrote:=20
>>> Are you sure you understood what was the question?
>>>
>>> Is the TBL1.CATEGORY = TBL2.CATEGORY the same as TBL1.CATEGORY &
>>> TBL2.CATEGORY > 0?

>
>> Yes, given that he stipulated that one and only one bit would be set.

>
> Really? In that case, isn't this bit-field just a bad implementation of
> an enum-style field?


My bad. I did misread it. Sorry, all.

-Kevin




---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Reply With Quote