Postgres Pro
Downloads
Home   >   mailing lists

Re: Formatting function, simple Q - Mailing list pgsql-novice

From nhrcommu@rochester.rr.com
Subject Re: Formatting function, simple Q
Date
Msg-id c417a3bc46971.46971c417a3bc@nyroc.rr.com
Whole thread Raw
In response to Re: Formatting function, simple Q  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view 
> 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.

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Formatting function, simple Q
Next
From: Howard Eglowstein
Date:
Subject: Stuck (again) trying to move a 7.x app and database to 8.2