Thomas Swan <tswan@ics.olemiss.edu> 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