[DOCS] unclear description for the Pattern Modifiers in formatting functions

2015-08-25 Thread Marc Mamin
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,'(9)') UNION ALL select

Re: [DOCS] unclear description for the Pattern Modifiers in formatting functions

2015-08-25 Thread Tom Lane
Marc Mamin writes: > 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. There are two separate tables (9-23, 9-25) showing which modifiers app