Postgres Pro
Downloads
Home   >   mailing lists

[DOCS] to_char(): 'FM' also suppresses *trailing* zeroes - Mailing list pgsql-docs

From Erwin Brandstetter
Subject [DOCS] to_char(): 'FM' also suppresses *trailing* zeroes
Date
Msg-id CAGHENJ7jgRbTn6nf48xNZ=FHgL2WQ4X8mYsUAU57f-vq8PubEw@mail.gmail.com
Whole thread Raw
Responses Re: [DOCS] to_char(): 'FM' also suppresses *trailing* zeroes
List pgsql-docs
Tree view
In Table 9-27. "Template Pattern Modifiers for Numeric Formatting" it says:

FM | prefix fill mode (suppress leading zeroes and padding blanks) | FM9999

https://www.postgresql.org/docs/current/static/functions-formatting.html#FUNCTIONS-FORMATTING-NUMERICMOD-TABLE

In fact, 'FM' also suppresses *trailing* zeroes after the comma. To fix, this might be changed to:

   suppress insignificant zeroes and padding blanks

Or:

   suppress padding zeroes and blanks

Regards
Erwin Brandstetter

pgsql-docs by date:

Previous
From: Thom Brown
Date:
Subject: [DOCS] Log rotation note
Next
From: ralph.holz@gmail.com
Date:
Subject: [DOCS] Requesting clarifying details on extract(epoch from timestamp)