Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> writes:
> On Fri, 28 Feb 2020 at 05:43, PG Bug reporting form
> <noreply(at)postgresql(dot)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