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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
