Inconsistency between TO_CHAR() and TO_NUMBER()

Поиск
Список
Период
Сортировка
От Patryk Kordylewski
Тема Inconsistency between TO_CHAR() and TO_NUMBER()
Дата
Msg-id 51878292.6080003@fooby.de
обсуждение исходный текст
Ответы Re: Inconsistency between TO_CHAR() and TO_NUMBER()
Список pgsql-bugs
Hi,

i have the following test-case:

http://psql.privatepaste.com/b3b431851a

We want to convert a TO_CHAR() formated numeric back to numeric using
TO_NUMBER() with the same format string. This does not work with a
german locale.

By removing the FM prefix and using the exact amount of digits in the
format string for TO_NUMBER() it starts to work. Switching the locale
back to en_US does work too.

Is this a bug or am i missing something?

Thanks!

Best regards,
Patryk

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: BUG #8135: current_setting('DateStyle'); does not reflect User setting
Следующее
От: jvalssilva@gmail.com
Дата:
Сообщение: BUG #8137: Instalação aparece erro