Subject | Re: [firebird-support] Error in power function in firebird 2.5 |
---|---|
Author | Mark Rotteveel |
Post date | 2015-08-12T11:15:20Z |
On Wed, 12 Aug 2015 13:00:57 +0200, "Jesus Garcia jegaza@...
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
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).
Mark
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
> In firebird documentation appears that in power function with an x valueSounds to me like it is a mistake in the documentation; the only condition
> 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?
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).
Mark