to_char(numeric type, text) rounding instead of truncating - Mailing list pgsql-docs

From PG Doc comments form
Subject to_char(numeric type, text) rounding instead of truncating
Date
Msg-id 168991536429.626.9957835774751337210@wrigleys.postgresql.org
Whole thread Raw
Responses Re: to_char(numeric type, text) rounding instead of truncating
List pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/15/functions-formatting.html
Description:

I've encountered an issue with to_char(numeric type, text)
Apparently, it uses rounding instead of truncation which leads to
unpexpected results. This is not reflected in the documentation.
My specific example:
select to_Char(1235::real/(2::real+1235::real)*100, '99%')
The expected output was 99%. The output was ##% - since the number was
rounded to 100, there wasn't enough digits in the format.
If I add a digit after the decimal point
select to_char(1235::real/(2::real+1235::real)*100,'90D0%')
The output becomes 99.8%

It would be nice to have this behavior explained in the documentation so
people get more predictable results.

pgsql-docs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Uniquness of ctid
Next
From: Laurenz Albe
Date:
Subject: Re: to_char(numeric type, text) rounding instead of truncating