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?
