Re: BUG #2037: user function call unexpected "input out of range" - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2037: user function call unexpected "input out of range"
Date
Msg-id 28310.1131815929@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2037: user function call unexpected "input out of range"  ("Tom" <lackey@ltu.edu>)
List pgsql-bugs
"Tom" <lackey@ltu.edu> writes:
> Description:        user function call unexpected "input out of range"

Why does this surprise you?  Floating point computation is inherently
inexact, so coming out with a value fractionally greater than 1 for
the acos() argument doesn't seem all that unlikely.  You probably
ought to add some code to clamp the result to the legal range.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "wgh"
Date:
Subject: BUG #2038: fetch items truncated
Next
From: Michael Fuhr
Date:
Subject: Re: BUG #2037: user function call unexpected "input out of range"