Re: Re: BETWEEN [SYMMETRIC | ASYMMETRIC]

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>

To: Thomas Swan <tswan-lst@ics.olemiss.edu>

Cc: pgsql-hackers@postgresql.org

Date: 2001-01-11T03:10:58Z

Lists: pgsql-hackers

Thomas Swan <tswan-lst@ics.olemiss.edu> writes:
> Actually if it were possible to look at the values before expanding.  You 
> could reorder the expression so that it was always the case that B < C, 
> then your cost would only be one comparison plus the sequential scan.

Uh ... what if B and C are not constants?

			regards, tom lane