Missing docs for "FM" in to_char(numeric) ?

Started by Steve Atkinsabout 18 years ago2 messagesdocs
Jump to latest
#1Steve Atkins
steve@blighty.com

Someone on irc was trying to format 1234 as "01234" and couldn't work
out how to get rid of the leading space - looking at the 8.3 docs it
looks as though the "FM" modifier isn't documented for numeric to_char.

So... should use of "FM" in numeric to_char() be documented in table
9-23, "Template Patterns for Numeric Formatting"?

It's included in the examples in 9-24, but doesn't seem to be
mentioned anywhere else. "FM" is listed in table 9-22, but that's for
"Date/Time Formatting", not numeric.

Cheers,
Steve

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Steve Atkins (#1)
Re: Missing docs for "FM" in to_char(numeric) ?

Am Dienstag, 12. Februar 2008 schrieb Steve Atkins:

Someone on irc was trying to format 1234 as "01234" and couldn't work
out how to get rid of the leading space - looking at the 8.3 docs it
looks as though the "FM" modifier isn't documented for numeric to_char.

I've added documentation about this. You should be able to see it at
http://developer.postgresql.org/pgdocs/postgres/functions-formatting.html in
a few minutes.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/