Re: Problem with retrieving records using double precision fields

Raymond C. Rodgers wrote:
> In two separate databases that are configured to have latitude and
> longitude as double precision fields, I'm having trouble retrieving
> records using "between" on the longitude field. I know that I have data
> within range, but any query involving the longitude field fails to find
> records.

> test=# select * from coordtest where longitude between -83.0 and -84.0;

Order of between arguments is important.

richardh=> SELECT 2 between 1 and 3;
 ?column?
----------
 t
(1 row)

richardh=> SELECT 2 between 3 and 1;
 ?column?
----------
 f
(1 row)

richardh=> SELECT -2 between -1 and -3;
 ?column?
----------
 f
(1 row)

--
  Richard Huxton
  Archonet Ltd