From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrey Rachitskiy <pl0h0yp1@gmail.com>
Cc: feasiblechart@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19615: COVAR_POP / COVAR_SAMP / REGR_SXY return 0.0 instead of NaN
Date: Wed, 12 Aug 2026 12:50:09 -0400
Message-ID: <2796774.1786553409@sss.pgh.pa.us> (raw)
In-Reply-To: <2395189.1786463799@sss.pgh.pa.us>
References: <19615-c7e390593416f6b6@postgresql.org>
<CAB8bMiu6BYW2TfQPaVs759e+Sf6UpZ_Ag60TfuDi57npfcY-yg@mail.gmail.com>
<2395189.1786463799@sss.pgh.pa.us>
I wrote:
> Yeah, I just arrived at pretty much the same conclusion. We get
> Inf/NaN handling right for Sxx and Syy, but not for the cross-product
> Sxy.
Pushed after some fooling with the comment and test cases.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, pl0h0yp1@gmail.com, feasiblechart@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19615: COVAR_POP / COVAR_SAMP / REGR_SXY return 0.0 instead of NaN
In-Reply-To: <2796774.1786553409@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox