Richard Huxton wrote:
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
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
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
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.
Here'
