Thread: Missing docs for "FM" in to_char(numeric) ?
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
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/