Re: BETWEEN SYMMETRIC/ASYMMETRIC - Mailing list pgsql-hackers

From Tom Lane
Subject Re: BETWEEN SYMMETRIC/ASYMMETRIC
Date
Msg-id 5439.1018451205@sss.pgh.pa.us
Whole thread Raw
In response to Re: BETWEEN SYMMETRIC/ASYMMETRIC  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses Re: BETWEEN SYMMETRIC/ASYMMETRIC
List pgsql-hackers
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> Also, Tom (or anyone): in regards to your previous email, should I just go
> back to using opt_symmetry to shorten the number of productions, since I
> have to make them reserved words anyway?

Might as well.  No point in writing more productions if it doesn't buy
anything.

BTW, I've forgotten whether your patch is purely syntactic or not,
but I'd really like to see someone fix things so that BETWEEN has its
own expression node tree type and is not expanded into some ugly
"A>=B and A<=C" equivalent.  This would (a) allow it to be
reverse-listed reasonably, and (b) eliminate redundant evaluations of
the subexpressions.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Justin Clift
Date:
Subject: [Fwd: AW: More UB-Tree patent information]
Next
From: Hannu Krosing
Date:
Subject: Re: [Fwd: AW: More UB-Tree patent information]