Re: Exponentiation confusion

2022-10-20 Thread Dean Rasheed
On Tue, 18 Oct 2022 at 20:18, Robert Haas wrote: > > On Tue, Oct 18, 2022 at 6:18 AM Dean Rasheed wrote: > > Overall, I'm quite happy with these results. The question is, should > > this be back-patched? > > > > In the past, I think I've only back-patched numeric bug-fixes where > > the digits ou

Re: Exponentiation confusion

2022-10-18 Thread Robert Haas
On Tue, Oct 18, 2022 at 6:18 AM Dean Rasheed wrote: > Overall, I'm quite happy with these results. The question is, should > this be back-patched? > > In the past, I think I've only back-patched numeric bug-fixes where > the digits output by the old code were incorrect or an error was > thrown, no

Re: Exponentiation confusion

2022-10-18 Thread Dean Rasheed
[Moving this to -hackers] > On 13/10/2022 18:20 CEST Adrian Klaver wrote: > > select power(10, -18::numeric); > > power > > > > 0. > > On Thu, 13 Oct 2022 at 18:17, Tom Lane wrote: > > An inexact result isn't surprising, but it shouldn't be *that* inexact. >