Re: Between Node

From: Rod Taylor <rbt(at)zort(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Between Node
Date: 2002-07-18 20:30:27
Message-ID: 1027024227.280.138.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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() ?

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2002-07-18 20:36:01 Re: Optional Oid
Previous Message Rod Taylor 2002-07-18 20:29:02 Re: Between Node