Re: Between Node

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: Between Node
Дата
Msg-id 1027024227.280.138.camel@jester
обсуждение исходный текст
Ответ на Re: Between Node  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Between Node  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
> In that case, this code is worse than before as far as developing plans
> goes.  The selectivity estimator needs to be taught about what BETWEEN
> means.  Currently it recognizes (x > foo AND x < bar) as a range query
> --- a BETWEEN node is obviously much easier to recognize, but you still
> have to add code to do it.

I simply multiple the results of the left, right and common expression
after sending them through clause_selectivity() ?


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

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Re: Between Node
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: minor GEQO fixes