On Fri, 30 Jul 2021 at 08:26, Dean Rasheed <dean.a.rash...@gmail.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
