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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Антон Потапов <su(dot)sinodan(at)gmail(dot)com>
Cc: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #17546: power() function - value is distorted via automatic type cast
Date: 2022-07-11 18:56:43
Message-ID: 1215877.1657565803@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?utf-8?B?0JDQvdGC0L7QvSDQn9C+0YLQsNC/0L7Qsg==?= <su(dot)sinodan(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Richard Guo 2022-07-12 04:35:48 Re: BUG #17545: Incorrect selectivity for IS NOT DISTINCT FROM and NULLs
Previous Message Антон Потапов 2022-07-11 16:04:04 Re: BUG #17546: power() function - value is distorted via automatic type cast