Re: BUG #14008: corr, covar_pop function returns different values on the same dataset - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #14008: corr, covar_pop function returns different values on the same dataset
Date
Msg-id 32087.1457547791@sss.pgh.pa.us
Whole thread Raw
In response to BUG #14008: corr, covar_pop function returns different values on the same dataset  (Stepya@ukr.net)
List pgsql-bugs
Stepya@ukr.net writes:
> Aggregation functions line corr, covar_pop returns different values
> depending on sorting order of the dataset.

AFAICS, that's just rounding error, which is inevitable when working
with floating-point data.

            regards, tom lane

pgsql-bugs by date:

Previous
From: gtakahashi@palantir.com
Date:
Subject: BUG #14010: Multi-valued Index-only scans do not properly handle nulls in search
Next
From: Tom Lane
Date:
Subject: Re: BUG #14010: Multi-valued Index-only scans do not properly handle nulls in search