Re: to_number nl_NL.utf8 - Mailing list pgsql-bugs

From Erik Rijkers
Subject Re: to_number nl_NL.utf8
Date
Msg-id cb9a97b252be8157caf8988671322410.squirrel@webmail.xs4all.nl
Whole thread Raw
In response to to_number nl_NL.utf8  ("Erik Rijkers" <er@xs4all.nl>)
Responses Re: to_number nl_NL.utf8  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Fri, December 27, 2013 23:14, Erik Rijkers wrote:
> Dutch locale uses a , as thousand separator, and . as decimal separator.

Sorry, that's wrong, of course.

Dutch locale uses a . as thousand separator, and , as decimal separator.

I was trying to import values like '1.234,55' into a en_US.utf8 database with

  to_number( '1.234,55'  ,  '999G999D99')

pgsql-bugs by date:

Previous
From: "Erik Rijkers"
Date:
Subject: to_number nl_NL.utf8
Next
From: Andrew Dunstan
Date:
Subject: Re: BUG #8676: Bug Money JSON