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.*,
(ACOS(COS(0.739317893219831)*COS(-1.24071147306354)*COS(RADIANS(lat))*COS(RADIANS(lng))+
COS(0.739317893219831)*SIN(-1.24071147306354)*COS(RADIANS(lat))*SIN(RADIANS(lng))+
SIN(0.739317893219831)*SIN(RADIANS(lat)))*3963)
AS distance from locations
ORDER BY distance ASC, locations.name
LIMIT 25 OFFSET 0
--
View this message in context: http://www.nabble.com/PGError%3A-input-out-of-range-tf4291698.html#a12217589
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
