| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com>, PostgreSQL Mailing List <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Formatting zeroes |
| Date: | 2002-09-17 05:33:26 |
| Message-ID: | 200209170533.g8H5XQq29077@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Josh Berkus wrote:
> Ludwig,
>
> > I'm trying to use SQL to generate a formatted
> > report. The "to_char(numeric,'FM9,999,999,999.99')"
> > function works when I use it format numbers with
> > decimal points and appropriate commas.
> > Is there a format specifier in the to_char function
> > that it will display 0 as "0" or "0.0"?
>
> "to_char(numeric,'FM9,999,999,999.09')"
And we know it is a bug:
* to_char(0,'FM999.99') returns a period, to_char(1,'FM999.99') does not
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ries van Twisk | 2002-09-17 06:36:36 | Re: Dublicates pairs in a table. |
| Previous Message | Bruce Momjian | 2002-09-17 03:12:06 | Re: How to select and result row number?? |