unclear description for the Pattern Modifiers in formatting functions

From: Marc Mamin <M(dot)Mamin(at)intershop(dot)de>
To: "'pgsql-docs(at)postgresql(dot)org'" <pgsql-docs(at)postgresql(dot)org>
Subject: unclear description for the Pattern Modifiers in formatting functions
Date: 2015-08-25 13:29:43
Message-ID: B6F6FD62F2624C4C9916AC0175D56D8828C20CF8@jenmbs01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

http://www.postgresql.org/docs/9.5/static/functions-formatting.html#FUNCTIONS-FORMATTING-DATETIMEMOD-TABLE

The page suggests that the pattern modifiers (e.g. 'FM') only apply for Date/Time Format.

But at least FM can also be used for number types:

select to_char(1,'(99999)')
UNION ALL
select to_char(1,'(FM99999)')
-----------------------------
( 1)
(1)

Maybe it would be sufficient to just add FM into the table 9.24
( http://www.postgresql.org/docs/9.5/static/functions-formatting.html#FUNCTIONS-FORMATTING-NUMERIC-TABLE )

regards,

Marc Mamin

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2015-08-25 23:45:57 Re: unclear description for the Pattern Modifiers in formatting functions
Previous Message Tom Lane 2015-08-14 14:32:41 Error in ALTER TABLE documentation