Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-patches by date

Next:From: Bruce MomjianDate: 2002-07-18 20:36:01
Subject: Re: Optional Oid
Previous:From: Rod TaylorDate: 2002-07-18 20:29:02
Subject: Re: Between Node

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group