Re: BUG #9793: to_number wrong convertion - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #9793: to_number wrong convertion
Date
Msg-id 16306.1396278923@sss.pgh.pa.us
Whole thread Raw
In response to BUG #9793: to_number wrong convertion  (info@gevnet.nl)
Responses Re: BUG #9793: to_number wrong convertion  ("GEV.NET" <info@gevnet.nl>)
List pgsql-bugs
info@gevnet.nl writes:
> My local is NL, so decimal separator is ','   whene i am calling
> to_number('123,45','999999D99') i am getting 12345  insted of 123.45 in de
> numeric filend in the database.
> In 9.2 is working correctly and in 9.3 no mo more.

AFAIK the behavior of that case didn't change in 9.3.  Are you sure you
have the locale settings of your database (particularly lc_numeric) the
same as you had in 9.2?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #9776: well formed json with embedd colon ':' causes error on copy
Next
From: Tom Lane
Date:
Subject: Re: BUG #9793: to_number wrong convertion