View Single Post

   
  #5 (permalink)  
Old 04-09-2008, 07:16 PM
Chris Travers
 
Posts: n/a
Default Re: Localization trouble



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

Reply With Quote