Re: Index usage when bitwise operator is used

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>>> On Mon, Sep 17, 2007 at  2:49 AM, in message
<1190015368.148293.56830@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>, valgog
<valgog@xxxxxxxxx> wrote: 

>> 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?

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



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux