Re: to_number nl_NL.utf8

From: "Erik Rijkers" <er(at)xs4all(dot)nl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: to_number nl_NL.utf8
Date: 2013-12-27 22:22:52
Message-ID: cb9a97b252be8157caf8988671322410.squirrel@webmail.xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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')

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Dunstan 2013-12-27 22:23:38 Re: BUG #8676: Bug Money JSON
Previous Message Erik Rijkers 2013-12-27 22:14:17 to_number nl_NL.utf8