Thread

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

Laurenz Albe <laurenz.albe@cybertec.at> — 2025-12-02T17:22:28Z

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