Re: BETWEEN patch

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