Re: Index usage when bitwise operator is used

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Index usage when bitwise operator is used
Дата
Msg-id 46EE4931.EE98.0025.0@wicourts.gov
обсуждение исходный текст
Ответ на Re: Index usage when bitwise operator is used  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
>>> 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




В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Index usage when bitwise operator is used
Следующее
От: "W.Alphonse HAROUNY"
Дата:
Сообщение: Re: Index usage when bitwise operator is used