At 1/24/2001 10:19 AM, Tom Lane wrote:
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
Thomas Swan [EMAIL PROTECTED] writes:
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.
After sending it... I realized that it was not correct
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
Granted this is brute force and not very elegant, however it
does provide the correct
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