Bug with locale (decimale/group seperator in numbers) - Mailing list pgsql-bugs

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If PostgreSQL failed to compile on your computer or you found a bug that
is likely to be specific to one platform then please fill out this form
and e-mail it to pgsql-ports@postgresql.org.

To report any other bug, fill out the form below and e-mail it to
pgsql-bugs@postgresql.org.

If you not only found the problem but solved it and generated a patch
then e-mail it to pgsql-patches@postgresql.org instead.  Please use the
command "diff -c" to generate the patch.

You may also enter a bug report at http://www.postgresql.org/ instead of
e-mail-ing this form.

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D
                        POSTGRESQL BUG REPORT TEMPLATE
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D


Your name               : Hannes Wenzel
Your email address      : hannes.wenzel@aon.at


System Configuration
- ---------------------
  Architecture (example: Intel Pentium)         : Intel Pentium III, 1133 M=
Hz

  Operating System (example: Linux 2.0.26 ELF)  : Linux 2.4.20 ELF

  PostgreSQL version (example: PostgreSQL-7.3.2):   PostgreSQL-7.3.2

  Compiler used (example:  gcc 2.95.2)          : gcc 3.2.3


Please enter a FULL description of your problem:
- ------------------------------------------------
A select with a to_char function to convert number to formated output with=
=20
locale support produces wrong group seperator characters.
The to_char function show a ',' as group seperator and ',' as decimal point=
.=20
So the group seperator is wrong, the decimal point is ok.

Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
- ----------------------------------------------------------------------
Created a database cluster with:

# initdb --pgdata=3D/home/postgres/db/home --locale=3Dde_AT.iso885915@euro=
=20
- --username=3Dhan

then the database with:

# createdb --owner han home

The Unix user id is 'postgres' the LANG environment variable was set to=20
'de_AT.iso885915@euro'.

The description of the corresponding table is:

home=3D# \d eur
                                    Tabelle =BBpublic.eur=AB
 Spalte |             Typ             |                      Attribute
- --------+-----------------------------+----------------------------------=
-------------------
 id     | integer                     | not null default=20
nextval('public.eur_id_seq'::text)
 datum  | timestamp without time zone | not null
 curr   | integer                     | not null
 val    | numeric(15,5)               | not null
Indizies: eur_pkey Prim=E4rschl=FCssel btree (id)
Foreign-Key-Constraints: $1 FOREIGN KEY (curr) REFERENCES currency(id) ON=
=20
UPDATE NO ACTION ON DELETE NO ACTION

Inserted some values into the table. The following select shows the followi=
ng=20
output:

home=3D# select val,to_char(val,'999G999G990D00') from eur;
 1719000.00000 |    1,719,000,00
    1389.50000 |        1,389,50
   37737.00000 |       37,737,00
 1737000.00000 |    1,737,000,00

The correct output should be as follows:

 1719000.00000 |    1.719.000,00
    1389.50000 |        1.389,50
   37737.00000 |       37.737,00
 1737000.00000 |    1.737.000,00

Feel free to contact me per e-mail if you have further questions.
- --=20
lg, Hannes
____________________________________________________________________

Key fingerprint =3D 33A2 A4F8 E6B9 C83F 65EF  7FD9 A6C2 3EDF DD3B 2E59
____________________________________________________________________
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux)

iD8DBQE+ywBkpsI+3907LlkRApxjAJ9s7E1Wiq9UWTP+lGMbzT7DR3Mn4gCfadam
dH/MqdxiRnAbbF1VaCyRw9M=3D
=3Dhnri
-----END PGP SIGNATURE-----