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
Re: Optimizer & boolean syntax Re: Optimizer & boolean syntax |
Список | 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 по дате отправления: