Re: [HACKERS] BETWEEN patch

[Tom Lane]

Thomas Swan <[EMAIL PROTECTED]> 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