Re: BETWEEN SYMMETRIC/ASYMMETRIC

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
Cc: "Gavin Sherry" <swm(at)linuxworld(dot)com(dot)au>, "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: BETWEEN SYMMETRIC/ASYMMETRIC
Date: 2002-04-10 15:06:45
Message-ID: 5439.1018451205@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2002-04-10 16:31:05 Re: [HACKERS] [Fwd: AW: More UB-Tree patent information]
Previous Message Justin Clift 2002-04-10 14:32:40 [Fwd: AW: More UB-Tree patent information]