 |
Bruce Momjian |
at Jan 25, 2011 at 9:26 pm
|
⇧ | 
| |
curt@net2business.com wrote:
The following bug has been logged online:
Bug reference: 5848
Logged by:
Email address: curt@net2business.com
PostgreSQL version: 8.1.22
Operating system: Centos 5.5
Description: Between operator issue
Details:
Statement 'A between B and C' always false if B is greater than C, even if A
falls between them.
I think you want BETWEEN SYMMETRIC:
<literal>BETWEEN SYMMETRIC</> is the same as <literal>BETWEEN</>
except there is no requirement that the argument to the left of
<literal>AND</> be less than or equal to the argument on the right.
If it is not, those two arguments are automatically swapped, so that
a nonempty range is always implied.
