Re: Between Node

Rod Taylor <rbt@zort.ca> writes:
> On Thu, 2002-07-18 at 00:56, Christopher Kings-Lynne wrote:
>> I believe Tom mentioned that having BETWEEN as a node would allow him to do
>> some sort of funky optimiser improvement.  Is that already done or does he
>> still need to do it?

> I don't know what improvement this would be.  I only touched the parser
> and executor.

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.

            regards, tom lane