From: | "Raymond C(dot) Rodgers" <sinful622(at)gmail(dot)com> |
---|---|
To: | |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Problem with retrieving records using double precision fields |
Date: | 2009-01-21 17:44:16 |
Message-ID: | 49775EF0.9060309@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 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)
>
>
Ok, so I made a simple math error (-83 being larger than -84) and didn't
catch it.
Thanks,
Raymond
From | Date | Subject | |
---|---|---|---|
Next Message | Carlos Gonzalez-Cadenas | 2009-01-21 18:09:28 | deductive databases in postgreSQL |
Previous Message | paulo matadr | 2009-01-21 17:44:14 | Res: [GENERAL] bytea size limit? |