On Wed, Jan 21, 2009 at 12:22:14PM -0500, Raymond C. Rodgers wrote:
> test=# select * from coordtest where latitude between 42.0 and 42.5 ;
The LHS value of a BETWEEN operator has to be of smaller value than the
RHS's value. You've got it correct above, but it's not correct here:
> test=# select * from coordtest where longitude between -83.0 and -84.0;
-83 is greater than -84.
--
Sam http://samason.me.uk/