Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 279762E2EBE for ; Mon, 11 Feb 2008 19:16:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 74825-02 for ; Mon, 11 Feb 2008 19:16:36 -0400 (AST) Received: from m.wordtothewise.com (fruitbat.wordtothewise.com [208.187.80.135]) by postgresql.org (Postfix) with ESMTP id 41B582E032A for ; Mon, 11 Feb 2008 19:16:42 -0400 (AST) Received: from platter.wordtothewise.com (184.wordtothewise.com [208.187.80.184]) by m.wordtothewise.com (Postfix) with ESMTP id ACEBA800C6 for ; Mon, 11 Feb 2008 15:16:40 -0800 (PST) Message-Id: <7942D79B-72C7-4CD8-B05F-F4F772DDC8EA@blighty.com> From: Steve Atkins To: pgsql-docs@postgresql.org Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v915) Subject: Missing docs for "FM" in to_char(numeric) ? Date: Mon, 11 Feb 2008 15:16:40 -0800 X-Mailer: Apple Mail (2.915) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/14 X-Sequence-Number: 4808 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