Re: BUG #5848: Between operator issue - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: BUG #5848: Between operator issue
Date
Msg-id 4D3EEBC40200002500039C7F@gw.wicourts.gov
Whole thread Raw
In response to BUG #5848: Between operator issue  ("" <curt@net2business.com>)
List pgsql-bugs
"" <curt@net2business.com> wrote:

> Statement 'A between B and C' always false if B is greater than C,
> even if A falls between them.

I'm pretty sure that's required by the standard, and doing otherwise
could break code which counts on standard semantics.

-Kevin

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #5848: Between operator issue
Next
From: Josh Berkus
Date:
Subject: Re: Multicolun index creation never completes on 9.0.1/solaris