Re: Localization trouble

From: Chris Travers <chris(at)travelamericas(dot)com>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Localization trouble
Date: 2007-07-06 01:24:59
Message-ID: 468D99EB.4070200@travelamericas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-07-06 01:59:42 Re: Localization trouble
Previous Message Michael Glaesemann 2007-07-06 01:15:02 Re: Localization trouble