Re: BETWEEN patch

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..