]> git.ipfire.org Git - thirdparty/postgresql.git/commit
projects / thirdparty / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 4893ead) | patch
Prevent corr() from returning the wrong results for negative correlation
authorNeil Conway <neilc@samurai.com>
Wed, 19 Sep 2007 22:31:48 +0000 (22:31 +0000)
committerNeil Conway <neilc@samurai.com>
Wed, 19 Sep 2007 22:31:48 +0000 (22:31 +0000)
commitbbf4fdc2538097bb3103806e1419ceef1f289203
treea965f57699c4eb681d5c4fad8a09df96b78e18b5tree | snapshot
parent4893eadc3ce58bb0793bd2cadd2e67f91c126a06commit | diff
Prevent corr() from returning the wrong results for negative correlation
values. The previous coding essentially assumed that x = sqrt(x*x), which
does not hold for x < 0.

Thanks to Jie Zhang at Greenplum and Gavin Sherry for reporting this
issue.
src/backend/utils/adt/float.c diff | blob | blame | history
Mirror of https://git.postgresql.org/git/postgresql.git