Postgres Pro
Downloads
Home   >   mailing lists

Re: Formatting zeroes - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Formatting zeroes
Date
Msg-id web-1649734@davinci.ethosmedia.com
Whole thread Raw
In response to Formatting zeroes  (Ludwig Lim <lud_nowhere_man@yahoo.com>)
Responses Re: Formatting zeroes  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
Tree view 
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')"

-Josh Berkus

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Dublicates pairs in a table.
Next
From: Bruce Momjian
Date:
Subject: Re: POSIX-style regular expressions