Locale Style - American numeric values to European numeric values

From: Elielson Fontanezi <ElielsonF(at)prodam(dot)sp(dot)gov(dot)br>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Locale Style - American numeric values to European numeric values
Date: 2002-07-31 18:27:12
Message-ID: A799F7647794D311924A005004ACEA97080DDEF3@cprodamibs249.prodam
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi fellow!

Problem: I am impossible to format numeric values from American to
European
style.

What have I done?

1. The Linux RH was settled to Brazilian locale:

LC_COLLATE=C
LC_CTYPE=C
LC_MESSAGES=pt_BR
LC_MONETARY=pt_BR
LC_NUMERIC=pt_BR
LC_TIME=pt_BR

2. PostGRE was compile with --enable-locale and
--enable-multibyte=UNICODE
3. $PGDATA was created doing: initdb -D $PGDATA -E UNICODE

4. In postgres db the table

create table leo(
codigo int2 primary key,
dia date,
valor numeric(10,2)
);

where

postgres$ psql -c "select * from leo";

codigo | dia | valor
--------+------------+--------
1 | 2002-02-02 | 200.00
(1 row)

The field dia and valor are still shown with american style.

What am I doing wrong.

Thanks.
..............................................
A Question...
Since before your sun burned hot in space
and before your race was born,
I have awaited a question.

Elielson Fontanezi
DBA Technical Support - PRODAM
Parque do Ibirapuera s/n - SP - BRAZIL
+55 11 5080 9493

Browse pgsql-admin by date

  From Date Subject
Next Message Elielson Fontanezi 2002-07-31 18:35:13 Locale Style - American numeric values to European numeri c values
Previous Message Chad R. Larson 2002-07-31 18:22:55 Re: 3-tier