Hello:
I'm having a problem with to_char(numeric, text) in certain locales
(mine, at least). I have configured with --enable-locale and initdb'd
with LC_ variables set to es_CL.
testing=# SELECT to_char(2000.5, '9G999D9');
to_char
----------
2,000,5
(1 row)
My locale specifies
$ locale -k LC_NUMERIC
decimal_point=","
thousands_sep=""
grouping=-1;-1
numeric-decimal-point-wc=44
numeric-thousands-sep-wc=0
numeric-codeset="ISO-8859-15"
It seems a glibc bug to me (the thousands_sep should be "."); however,
it seems also a Postgres bug as it is using the C locale standard
thousands separator. If I redefine the es_CL locale with the right
settings, it works ok.
This is the current REL7_2_STABLE CVS version under Linux 2.4.19 and
glibc 2.2.4.
--
Alvaro Herrera (<alvherre[a]atentus.com>)
"Ni aun el genio muy grande llegaria muy lejos
si tuviera que sacarlo todo de su propio interior" (Goethe)