Re: Localization trouble - Mailing list pgsql-general

From Chris Travers
Subject Re: Localization trouble
Date
Msg-id 468D99EB.4070200@travelamericas.com
Whole thread Raw
In response to Re: Localization trouble  (Michael Fuhr <mike@fuhr.org>)
Responses Re: Localization trouble  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

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?

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Localization trouble
Next
From: Tom Lane
Date:
Subject: Re: Localization trouble