Subject Re: [firebird-support] Error in power function in firebird 2.5
Author Mark Rotteveel
On Wed, 12 Aug 2015 13:00:57 +0200, "Jesus Garcia jegaza@...
[firebird-support]" <> wrote:
> In firebird documentation appears that in power function with an x value
> negative, an error is raised, but I can execute in firebird 2.5
> *select power(-3.215,2) from rdb$database*
> where is the mistake, function or docs?

Sounds to me like it is a mistake in the documentation; the only condition
I can think of where this would apply is x < 0 and -1 > y < 1, for example
power(-1, 0.5) is an imaginary number which can't be represented by a
double precision, or maybe x = 0 and y < 0: power(0, -1) would be a
division by zero (although NaN might be a valid result here).