to_char(numeric type, text) rounding instead of truncating

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: barsikdacat(at)gmail(dot)com
Subject: to_char(numeric type, text) rounding instead of truncating
Date: 2023-07-21 04:56:04
Message-ID: 168991536429.626.9957835774751337210@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Laurenz Albe 2023-07-26 05:53:36 Re: to_char(numeric type, text) rounding instead of truncating
Previous Message David G. Johnston 2023-07-19 21:39:09 Re: Uniquness of ctid