unclear description for the Pattern Modifiers in formatting functions - Mailing list pgsql-docs

From Marc Mamin
Subject unclear description for the Pattern Modifiers in formatting functions
Date
Msg-id B6F6FD62F2624C4C9916AC0175D56D8828C20CF8@jenmbs01.ad.intershop.net
Whole thread Raw
Responses Re: unclear description for the Pattern Modifiers in formatting functions
List 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




pgsql-docs by date:

Previous
From: Tom Lane
Date:
Subject: Error in ALTER TABLE documentation
Next
From: Tom Lane
Date:
Subject: Re: unclear description for the Pattern Modifiers in formatting functions