Re: BUG #15758: regr_* return wrong answers for some valid data

Pg 12 does fix the problem, and the numbers are slightly better than
that of Gnumeric and LibreOffice Calc.

2019/4/16 21:41, Jeff Janes:
> On Tue, Apr 16, 2019 at 3:55 AM PG Bug reporting form
> <noreply(at)postgresql(dot)org <mailto:noreply(at)postgresql(dot)org>> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference:      15758
> Logged by:          Dingyuan Wang
> Email address: gumblex(at)aosc(dot)io <mailto:gumblex(at)aosc(dot)io>
> PostgreSQL version: 11.2
> Operating system:   Debian
> Description:
>
> This can reproduce on at least version 10 or 11, on Debian amd64.
> Given the following data:
>
>
> This will be improved in version 12 when that is released later this
> year.  See the below commit:
>
> commit e954a727f0c8872bf5203186ad0f5312f6183746
> Author: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com
> <mailto:dean(dot)a(dot)rasheed(at)gmail(dot)com>>
> Date:   Sat Oct 6 11:20:09 2018 +0100
>
>     Improve the accuracy of floating point statistical aggregates.
>
>
>
> Cheers,
>
> Jeff