Re: BUG #9793: to_number wrong convertion

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #9793: to_number wrong convertion
Дата
Msg-id 16306.1396278923@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #9793: to_number wrong convertion  (info@gevnet.nl)
Ответы Re: BUG #9793: to_number wrong convertion  ("GEV.NET" <info@gevnet.nl>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #9776: well formed json with embedd colon ':' causes error on copy
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #9793: to_number wrong convertion