Re: Re: BETWEEN [SYMMETRIC | ASYMMETRIC] - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Re: BETWEEN [SYMMETRIC | ASYMMETRIC]
Date
Msg-id 10223.979182658@sss.pgh.pa.us
Whole thread Raw
In response to Re: BETWEEN [SYMMETRIC | ASYMMETRIC]  (Thomas Swan <tswan-lst@ics.olemiss.edu>)
Responses Re: Re: BETWEEN [SYMMETRIC | ASYMMETRIC]  (Thomas Swan <tswan-lst@ics.olemiss.edu>)
List 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: GiST for 7.1 !!
Next
From: Thomas Lockhart
Date:
Subject: Re: AW: AW: Re: tinterval - operator problems on AIX