Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 5CCAD2E009A for ; Tue, 26 Feb 2008 11:33:39 -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 16673-03 for ; Tue, 26 Feb 2008 11:33:29 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from gauss.credativ.com (gauss.credativ.com [212.112.227.254]) by postgresql.org (Postfix) with ESMTP id E43512E0098 for ; Tue, 26 Feb 2008 11:33:37 -0400 (AST) Received: from hawking.credativ.lan (exit.credativ.com [87.139.82.80]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id 0CB0177566; Tue, 26 Feb 2008 16:33:35 +0100 (CET) From: Peter Eisentraut To: pgsql-docs@postgresql.org Subject: Re: Missing docs for "FM" in to_char(numeric) ? Date: Tue, 26 Feb 2008 16:33:33 +0100 User-Agent: KMail/1.9.7 Cc: Steve Atkins References: <7942D79B-72C7-4CD8-B05F-F4F772DDC8EA@blighty.com> In-Reply-To: <7942D79B-72C7-4CD8-B05F-F4F772DDC8EA@blighty.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200802261633.34345.peter_e@gmx.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/17 X-Sequence-Number: 4811 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/