Fix formatting of to_char's EEEE output for numeric and bigint. The integer and float code paths for EEEE format always produce a single digit before the decimal point. However, the numeric code path (shared by bigint) was careless about rounding: if rounding increased the value from, say, 9.999 to 10.00, it got printed that way. Fix that. Given the precedent of the other code paths, this seems incontestably a bug, so back-patch.
While at it, provide some actual documentation about what this format code is supposed to do, rather than leaving it to the reader's imagination. Author: Jianqiao Han <[email protected]> Reviewed-by: Tom Lane <[email protected]> Discussion: https://postgr.es/m/CAPOa_Zkc1QROJwB_JcB+f=6s1bUPRh7qr_H_=b_s-kzpa0v...@mail.gmail.com Backpatch-through: 15 Branch ------ REL_18_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/cdd975becc5f378269e1d5bec71c2804d775ccab Modified Files -------------- doc/src/sgml/func.sgml | 12 +++++++++--- src/backend/utils/adt/numeric.c | 16 ++++++++++++++++ src/test/regress/expected/numeric.out | 24 ++++++++++++++++++++++++ src/test/regress/sql/numeric.sql | 13 +++++++++++++ 4 files changed, 62 insertions(+), 3 deletions(-)
