Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group