Re: BETWEEN patch - Mailing list pgsql-hackers

From Thomas Swan
Subject Re: BETWEEN patch
Date
Msg-id 5.0.2.1.0.20010124132253.02f1aea0@tangent.ics.olemiss.edu
Whole thread Raw
In response to Re: BETWEEN patch  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BETWEEN patch  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
At 1/24/2001 10:19 AM, Tom Lane wrote:
>Thomas Swan <tswan@ics.olemiss.edu> writes:
> > A patch to gram.y in src/backend/parser
> > Provides for the SQL99 expected behavior of
> >          select * from foo where fo_num between 1 and 5
> > yields the same result as
> >          select * from foo where fo_num between 5 and 1
>
>This is NOT correct under either SQL92 or SQL99.  Read the spec again.
>
>                         regards, tom lane

After sending it... I realized that it was not correct either.   So,  I'm 
back to figuring how to do it... so, um, ignore the previous patch...

Thanks..



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: beta3 Solaris 7 (SPARC) port report [ Was: Looking for . . . ]
Next
From: Peter Eisentraut
Date:
Subject: Re: RPM: Contrib request.