| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Hannes Wenzel <h(dot)wenzel(at)aon(dot)at> |
| Cc: | pgsql-bugs(at)postgresql(dot)org, hannes(dot)wenzel(at)aon(dot)at |
| Subject: | Re: Bug with locale (decimale/group seperator in numbers) |
| Date: | 2003-05-22 14:04:16 |
| Message-ID: | 16939.1053612256@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hannes Wenzel <h(dot)wenzel(at)aon(dot)at> writes:
> A select with a to_char function to convert number to formated output with
> locale support produces wrong group seperator characters.
I think this must be a bug in the definition of that particular locale
on your system. I get reasonable-looking behavior here:
regression=# select to_char(1719000.00000,'999G999G990D00');
to_char
-----------------
1,719,000.00
(1 row)
regression=# set lc_numeric TO 'de_DE(dot)iso885915(at)euro';
SET
regression=# select to_char(1719000.00000,'999G999G990D00');
to_char
-----------------
1.719.000,00
(1 row)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-05-22 15:45:53 | Re: Different results in a loop with RECORD vs ROWTYPE... |
| Previous Message | Sean Chittenden | 2003-05-22 10:56:54 | Re: Different results in a loop with RECORD vs ROWTYPE... |