public inbox for [email protected]
help / color / mirror / Atom feedunclear description for the Pattern Modifiers in formatting functions
2+ messages / 2 participants
[nested] [flat]
* unclear description for the Pattern Modifiers in formatting functions
@ 2015-08-25 13:29 Marc Mamin <[email protected]>
2015-08-25 23:45 ` Re: unclear description for the Pattern Modifiers in formatting functions Tom Lane <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Marc Mamin @ 2015-08-25 13:29 UTC (permalink / raw)
To: pgsql-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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: unclear description for the Pattern Modifiers in formatting functions
2015-08-25 13:29 unclear description for the Pattern Modifiers in formatting functions Marc Mamin <[email protected]>
@ 2015-08-25 23:45 ` Tom Lane <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2015-08-25 23:45 UTC (permalink / raw)
To: Marc Mamin <[email protected]>; +Cc: pgsql-docs
Marc Mamin <[email protected]> writes:
> 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.
There are two separate tables (9-23, 9-25) showing which modifiers apply
for date/time and numeric cases, so I think it is fine as-is.
Mind you, the whole page is rather awkward. Perhaps it would benefit from
being thrown away and rewritten from scratch. I'm not volunteering though.
regards, tom lane
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2015-08-25 23:45 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-08-25 13:29 unclear description for the Pattern Modifiers in formatting functions Marc Mamin <[email protected]>
2015-08-25 23:45 ` Tom Lane <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox