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.
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 |