Re: [HACKERS] BETWEEN patch
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 either. So, I'm > back to figuring how to do it... so, um, ignore the previous patch... Someone (Easter, IIRC) already submitted a patch to support the SQL99 SYMMETRIC BETWEEN option. I think we're sitting on it till 7.2, on the grounds of "no new features in beta". Check the list archives for the last few weeks if you need it now. regards, tom lane
Re: [HACKERS] BETWEEN patch
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 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..
Re: [HACKERS] BETWEEN patch
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