Re: BUG #16281: LN() function inaccurate at 1000th fractional digit - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #16281: LN() function inaccurate at 1000th fractional digit
Date
Msg-id 962.1582904341@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #16281: LN() function inaccurate at 1000th fractional digit  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: BUG #16281: LN() function inaccurate at 1000th fractional digit  (Dean Rasheed <dean.a.rasheed@gmail.com>)
List pgsql-bugs
Dean Rasheed <dean.a.rasheed@gmail.com> writes:
> On Fri, 28 Feb 2020 at 05:43, PG Bug reporting form
> <noreply@postgresql.org> wrote:
>> The last digit should be a 2, but pg thinks it's a 3,

> Yeah, that's not at all surprising. All the transcendental numeric
> functions are basically +/-1 in the final digit.

TBH, I'd be ecstatic if I thought that was the maximum possible error ;-).
I don't think anyone's really done any error propagation analysis on
the numeric transcendentals.

            regards, tom lane



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16283: crash on create index segmentation fault
Next
From: Tomas Vondra
Date:
Subject: Re: BUG #16283: crash on create index segmentation fault