From: | dustov <dustov(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | PGError: input out of range |
Date: | 2007-08-18 22:21:02 |
Message-ID: | 12217589.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2007-08-18 23:07:46 | Re: SUBSTRING performance for large BYTEA |
Previous Message | Michelle Konzack | 2007-08-18 21:40:19 | Re: SELECT question |