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 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 your query that I can imagine being out of range is > ACOS() which would need to be between -1 and 1 (otherwise the result > would be complex). > > I'd try and see what the argument to the ACOS is, but it's probably > some corner case where the rounding is getting you. > > Hope this helps, > -- > Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ >> From each according to his ability. To each according to his ability to >> litigate. > > > -- View this message in context: http://www.nabble.com/PGError%3A-input-out-of-range-tf4291698.html#a12376732 Sent from the PostgreSQL - general mailing list archive at Nabble.com. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
