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

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Oleg Ivanov <o15611(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19340: Wrong result from CORR() function
Date: 2025-12-02 17:22:28
Message-ID: b1f0013e580158446ef0841acdc7301119a8ce8f.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2025-12-02 17:25:52 Re: BUG #19341: REPLACE() fails to match final character when using nondeterministic ICU collation
Previous Message Tom Lane 2025-12-02 17:22:07 Re: BUG #19340: Wrong result from CORR() function