Re: Optimizer & boolean syntax

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Optimizer & boolean syntax
Дата
Msg-id 004f01c291af$b435e350$6600a8c0@internal
обсуждение исходный текст
Ответ на Re: Optimizer & boolean syntax  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Ответы Re: Optimizer & boolean syntax  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: Optimizer & boolean syntax  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: Optimizer & boolean syntax  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-hackers
> > I think his point is that they _should_ be equivalent.  Surely there's
> > something in the optimiser that discards '=true' stuff, like 'a=a'
should be
> > discarded?
>
> I figure that's what he meant, but it isn't what was said. ;)
>
> "col" isn't of the general form "indexkey op constant" or "constant op
> indexkey" which I presume it's looking for given the comments in
> indxpath.c.  I'm not sure what the best way to make it work would be given
> that presumably we'd want to make col IS TRUE/FALSE use an index at the
> same time (since that appears to not do so as well).

Not that I see the point of indexing booleans, but hey :)

Chris




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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Optimizer & boolean syntax
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Optimizer & boolean syntax