Re: thousands comma numeric formatting in psql

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Eugen Nedelcu <eugen(at)sifolt(dot)ro>, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: thousands comma numeric formatting in psql
Date: 2005-07-14 21:28:04
Message-ID: 200507142128.j6ELS4g19112@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > OK, I have applied the following patch to make numerisep a boolean,
>
> "numericsep" is no longer even remotely reasonable as a name for the
> parameter. Something like "numeric_use_locale" would be appropriate
> (but probably too wordy).

Basically, with the C locale, it changes 1000.00 to 1,000.00, so indeed
is does add a numeric separator. For a European locale, 1000.00 becomes
1.000,00. so in that case is changes both the separator and decimal
marker. We don't currently have a way to display 1000.00 as 1000,00.

I am thinking of calling it just numericlocale.

--
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

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2005-07-14 21:49:37 Re: Change Ownership Permission Checks
Previous Message Bruce Momjian 2005-07-14 21:13:43 Re: thousands comma numeric formatting in psql