Re: BUG #17546: power() function - value is distorted via automatic type cast - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #17546: power() function - value is distorted via automatic type cast
Date
Msg-id 1215877.1657565803@sss.pgh.pa.us
Whole thread Raw
In response to BUG #17546: power() function - value is distorted via automatic type cast  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
=?utf-8?B?0JDQvdGC0L7QvSDQn9C+0YLQsNC/0L7Qsg==?= <su.sinodan@gmail.com> writes:
> Is there any chance that you will reflect this in the documentation?

It is documented --- see under
    https://www.postgresql.org/docs/current/datatype-numeric.html
and
    https://www.postgresql.org/docs/current/typeconv.html
(particularly example 10.3, which points out that float8 is
considered a preferred type).  We are not going to repeat all that
material under every single affected function, if that's what
you're asking for.

            regards, tom lane



pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #17546: power() function - value is distorted via automatic type cast
Next
From: Richard Guo
Date:
Subject: Re: BUG #17545: Incorrect selectivity for IS NOT DISTINCT FROM and NULLs