Re: BUG #9793: to_number wrong convertion

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: info(at)gevnet(dot)nl
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #9793: to_number wrong convertion
Date: 2014-03-31 15:15:23
Message-ID: 16306.1396278923@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

info(at)gevnet(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message GEV.NET 2014-03-31 15:25:48 Re: BUG #9793: to_number wrong convertion
Previous Message Tom Lane 2014-03-31 15:07:06 Re: BUG #9776: well formed json with embedd colon ':' causes error on copy