Request a Demo
Home   >   mailing lists

Re: BUG #19340: Wrong result from CORR() function - Mailing list pgsql-bugs

From Laurenz Albe
Subject Re: BUG #19340: Wrong result from CORR() function
Date
Msg-id b1f0013e580158446ef0841acdc7301119a8ce8f.camel@cybertec.at
Whole thread Raw
In response to Re: BUG #19340: Wrong result from CORR() function  (Oleg Ivanov <o15611@gmail.com>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #19340: Wrong result from CORR() function
Next
From: Tom Lane
Date:
Subject: Re: BUG #19341: REPLACE() fails to match final character when using nondeterministic ICU collation