Re: Problem with retrieving records using double precision fields - Mailing list pgsql-general

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/