Postgres Pro
Downloads
Home   >   mailing lists

PGError: input out of range - Mailing list pgsql-general

From dustov
Subject PGError: input out of range
Date
Msg-id 12217589.post@talk.nabble.com
Whole thread Raw
Responses Re: PGError: input out of range  (Martijn van Oosterhout <kleptog@svana.org>)
Re: PGError: input out of range  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: "Jayaprakash, Sowmiya Lakshmi (STSD)"
Date:
Subject: Solution to Bus error(coredump) from postgres binary
Next
From: Ron Mayer
Date:
Subject: Re: Enterprise Wide Deployment