public inbox for [email protected]  

help / color / mirror / Atom feed

From: Marc Mamin <[email protected]>
To: '[email protected]' <[email protected]>
Subject: unclear description for the Pattern Modifiers in formatting functions
Date: Tue, 25 Aug 2015 13:29:43 +0000
Message-ID: <B6F6FD62F2624C4C9916AC0175D56D8828C20CF8@jenmbs01.ad.intershop.net> (raw)
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>

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

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-TAB... )



regards,

Marc Mamin




-- 
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: unclear description for the Pattern Modifiers in formatting functions
  In-Reply-To: <B6F6FD62F2624C4C9916AC0175D56D8828C20CF8@jenmbs01.ad.intershop.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox