Received: from ara.zf.jcu.cz (ara.zf.jcu.cz [160.217.161.4]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3K7so379353 for ; Fri, 20 Apr 2001 03:54:51 -0400 (EDT) (envelope-from zakkr@zf.jcu.cz) Received: (from zakkr@localhost) by ara.zf.jcu.cz (8.9.3/8.9.3/Debian 8.9.3-21) id JAA23060; Fri, 20 Apr 2001 09:54:33 +0200 Date: Fri, 20 Apr 2001 09:54:33 +0200 From: Karel Zak To: Mark Stosberg Cc: pgsql-sql@postgresql.org Subject: Re: function to format floats as money? (removing space padding) Message-ID: <20010420095432.C21932@ara.zf.jcu.cz> References: <3ADC61E0.93E7865D@summersault.com> <3ADF4218.6604D76C@summersault.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0.1i In-Reply-To: <3ADF4218.6604D76C@summersault.com>; from mark@summersault.com on Thu, Apr 19, 2001 at 02:53:38PM -0500 X-Archive-Number: 200104/336 X-Sequence-Number: 2694 On Thu, Apr 19, 2001 at 02:53:38PM -0500, Mark Stosberg wrote: > > Now that I've figured out that numeric is good for storing money, and > that I can format with like this: > > to_char(price, '9,999,999.99') as price > > Then I discovered that sometimes this returns leading spaces I don't > want. I can get rid of them like this: > > trim(to_char(price, '9,999,999.99')) as price > > Is that the recommended money formatting style, for amounts less than > 9,999,999.99? (assuming I'll tack on my own currency symbol? ). Other > there other general styles that folks like for this? Thanks, May be try docs, what? :-) test=# select to_char(123456, '9,999,999.99'); to_char --------------- 123,456.00 (1 row) test=# select to_char(123456, 'FM9,999,999.99'); to_char --------- 123,456 (1 row) test=# select to_char(123456, 'FM9,999,999.00'); to_char ------------ 123,456.00 (1 row) test=# select to_char(123, 'FM0,999,999.00'); to_char -------------- 0,000,123.00 (1 row) test=# select to_char(123456, 'LFM9,999,999.00'); to_char ------------ $123,456.00 (1 row) FM ....fill mode, skip blank spaces and zeroes (if not set '0' instead '9') L ....currency symbol (from actual locales) Right? Karel -- Karel Zak http://home.zf.jcu.cz/~zakkr/ C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz