Michael Fuhr wrote:
I think you'll need to use to_char():
test=> set lc_numeric to 'es_ES.UTF-8';
SET
test=> select to_char(1.234, '9D999');
to_char
---------
1,234
(1 row)
The file src/backend/utils/adt/pg_locale.c in the PostgreSQL source
code has comments about how various LC_* settings are used in the
backend.
Is there a way to accept localized numbers as input?
i.e. '1,39'::numeric?
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings