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@postgresql.org <mailto:noreply@postgresql.org>> wrote:
> 
>     The following bug has been logged on the website:
> 
>     Bug reference:      15758
>     Logged by:          Dingyuan Wang
>     Email address: gumblex@aosc.io <mailto:gumblex@aosc.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.a.rasheed@gmail.com 
> <mailto:dean.a.rasheed@gmail.com>>
> Date:   Sat Oct 6 11:20:09 2018 +0100
> 
>      Improve the accuracy of floating point statistical aggregates.
> 
> 
> 
> Cheers,
> 
> Jeff