The problem was indeed ACOS() being outside of the [-1,1] range, and this
happened because it was calculating the distance between the same LAT,LONG
pair (the same location)
I added a WHERE L1.ID <> L2.ID to stop the reflexive calculation.
Martijn van Oosterhout wrote:
>
> On Sat, Aug 18, 2007
dustov <[EMAIL PROTECTED]> writes:
> PGError: ERROR: input is out of range
I see no such error string in the current sources ... what Postgres
version are you using?
If you set "\set VERBOSITY verbose" in psql before trying the query,
you should get some extra info about where the message is com
On Sat, Aug 18, 2007 at 03:21:02PM -0700, dustov wrote:
>
> My database just had this new error, and I have no idea why (because I
> haven't intentionally made any changes to this table). Does anyone have an
> idea which input is out of range-- or what the problem might be?
The only thing in yo
My database just had this new error, and I have no idea why (because I
haven't intentionally made any changes to this table). Does anyone have an
idea which input is out of range-- or what the problem might be?
Thanks,
Dustin
PGError: ERROR: input is out of range
: SELECT DISTINCT locations.*
