Folks,
Why does BETWEEN only work for ascending criteria? For example:
jwnet=> select '2002-06-07'::TIMESTAMP BETWEEN '2002-06-29'::TIMESTAMP and
'2002-06-01'::TIMESTAMP;
?column?
----------
f
(1 row)
jwnet=> select '2002-06-07'::TIMESTAMP BETWEEN '2002-06-01'::TIMESTAMP and
'2002-06-29'::TIMESTAMP;
?column?
----------
t
(1 row)
The above behaviour does not seem logical; is this a SQL spec thing, or a bug?
--
-Josh Berkus