Re: BUG #2037: user function call unexpected "input out of range"

On Fri, Nov 11, 2005 at 09:26:47PM +0000, Tom wrote:
>=20
> The following bug has been logged online:
>=20
> Bug reference:      2037
> Logged by:          Tom
> Email address:      lackey@ltu.edu
> PostgreSQL version: 8.1-beta4
> Operating system:   Windows XP
> Description:        user function call unexpected "input out of range"
> Details:=20

[ basically acos(sin(w1)*sin(w2) + cos(w1)*cos(w2)*cos(l1-l2)) ]

Seems to me that you are hitting an unfortunate roundoff error, where
the argument to acos is slightly greater than 1 (it will be
mathematically 1 in the case w1=3D=3Dw2 and l1=3D=3Dl2).

Maybe you should limit the argument to acos to -1..+1?

regards
-- tom=C3=A1s