Re: BETWEEN patch - Mailing list pgsql-hackers

From Tom Lane
Subject Re: BETWEEN patch
Date
Msg-id 12723.980353154@sss.pgh.pa.us
Whole thread Raw
In response to BETWEEN patch  (Thomas Swan <tswan@ics.olemiss.edu>)
Responses Re: BETWEEN patch
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Libpq async issues
Next
From: Alfred Perlstein
Date:
Subject: Re: Libpq async issues