Re: thousands comma numeric formatting in psql

From: Eugen Nedelcu <eugen(at)sifolt(dot)ro>
To: pgsql-patches(at)postgresql(dot)org
Subject: Re: thousands comma numeric formatting in psql
Date: 2005-06-22 08:54:40
Message-ID: 20050622085440.GA371@sifolt.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Hello,

I have included my patch attached to this mail.

I have made the changes to deal with locale settings from client
environment. So now you can start psql like this:

(export LC_ALL=ro_RO; psql -U user db)

and have numeric formatting with '.' as thousands separator and
',' as decimal point, or

(export LC_ALL=en_US; psql -U user db)

and have numeric formatting with ',' as thousands separator and
'.' as decimal point. This formatting is default when locale is 'C'

You can set any locale and numeric formatting code will take it in
consideration.

This patch is for version 7.3.2. The steps for install is:

1) cp thousands_comma.diff $POSTGRES_DIR/src/bin/psql
2) cd $POSTGRES_DIR/src/bin/psql
3) patch -p0 < thousands_comma.diff
4) ../../../configure && make

Best Regards,
Eugen

Attachment Content-Type Size
thousands_comma.diff text/plain 15.6 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Cramer 2005-06-22 11:20:47 Re: PROPOSAL FE/BE extension to handle IN/OUT parameters
Previous Message Dave Page 2005-06-22 08:20:38 Re: Server instrumentation patch

Browse pgsql-patches by date

  From Date Subject
Next Message Andrew Dunstan 2005-06-22 11:25:57 Re: pl/pgsql: END verbosity
Previous Message Neil Conway 2005-06-22 05:29:44 Re: pl/pgsql: END verbosity