> Anyway, I think you need 'FM' to get rid of the unused space.
> regression=# select to_char(485, 'FML999');
> (1 row)
Thanks Tom. Exactly what I was looking for.
In response to
pgsql-novice by date
|Next:||From: Howard Eglowstein||Date: 2007-06-15 18:07:31|
|Subject: Stuck (again) trying to move a 7.x app and database to 8.2|
|Previous:||From: Tom Lane||Date: 2007-06-15 14:20:14|
|Subject: Re: Formatting function, simple Q |