Re: function to format floats as money? (removing space padding) - Mailing list pgsql-sql

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,
 -mark

personal website             }      Summersault Website Development
http://mark.stosberg.com/    {      http://www.summersault.com/