Re: thousands comma numeric formatting in psql

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

Bruce Momjian wrote:
> 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.

Done, and attached.

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

Attachment Content-Type Size
unknown_filename text/plain 25.5 KB

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Titus von Boxberg 2005-07-18 22:11:13 Re: PL/PGSQL: Dynamic Record Introspection
Previous Message Rocco Altier 2005-07-18 20:12:37 Re: Changes for AIX buildfarm