Horton

Re: BUG #19340: Wrong result from CORR() function

Laurenz Albe <laurenz.albe@cybertec.at>

View thread
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Oleg Ivanov <o15611@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Date: 2025-12-02T17:22:28Z
Lists: pgsql-bugs 
On Tue, 2025-12-02 at 17:05 +0300, Oleg Ivanov wrote:
> Yes, must be NULL in all the queries I have provided!
> But PostgreSQL curr() returns numbers, wich is incorrect.

I see.
I guess these are rounding errors, which are to be expected with
floating point numbers.  But perhaps we could do better.

Yours,
Laurenz Albe