PGError: input out of range

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.

Responses

Browse pgsql-general by date

  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