Re: Between Node - Mailing list pgsql-patches

From Rod Taylor
Subject Re: Between Node
Date
Msg-id 1027024227.280.138.camel@jester
Whole thread Raw
In response to Re: Between Node  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Between Node  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Between Node
Next
From: Bruce Momjian
Date:
Subject: Re: minor GEQO fixes