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