Re: Division by zero error in to_char(num, '9.9EEEE')

On Fri, 30 Jul 2021 at 08:26, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> wrote:
>
> SELECT to_char(1.2e-1002, '9.9EEEE'); -- fails
> ERROR: division by zero
>
> I think the simplest
> solution is to just introduce a new local function, as in the attached
> patch. This directly constructs 10^n, for integer n, which is pretty
> trivial, and doesn't need any numeric multiplication or rounding.
>

Unless there are any objections, I intend to push this shortly. I
think it's a fairly straightforward bug fix, and I want to be able to
use to_char() in some new numeric regression tests.

Regards,
Dean