Re: Formatting function, simple Q

From: nhrcommu(at)rochester(dot)rr(dot)com
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Formatting function, simple Q
Date: 2007-06-15 14:45:08
Message-ID: c417a3bc46971.46971c417a3bc@nyroc.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> Anyway, I think you need 'FM' to get rid of the unused space.
>
> regression=# select to_char(485, 'FML999');
> to_char
> ---------
> $485
> (1 row)

Thanks Tom. Exactly what I was looking for.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Howard Eglowstein 2007-06-15 18:07:31 Stuck (again) trying to move a 7.x app and database to 8.2
Previous Message Tom Lane 2007-06-15 14:20:14 Re: Formatting function, simple Q