Re: Inconsistency between TO_CHAR() and TO_NUMBER()

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: Inconsistency between TO_CHAR() and TO_NUMBER()
Дата
Msg-id kmj64d$qrq$1@ger.gmane.org
обсуждение исходный текст
Ответ на Re: Inconsistency between TO_CHAR() and TO_NUMBER()  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Inconsistency between TO_CHAR() and TO_NUMBER()
Список pgsql-bugs
Tom Lane wrote on 10.05.2013 17:49:
> I looked into this, and find that the reason it misbehaves is that
> NUM_numpart_from_char() will treat a '.' as being a decimal point
> *without any regard to locale considerations*.  So even if we have
> a locale-dependent format string and a locale that says '.' is a
> thousands separator, it does the wrong thing.
>
> It's a bit surprising nobody's complained of this before.
>
> I propose the attached patch.  I'm slightly worried though about whether
> this might break any existing applications that are (incorrectly)
> depending on a D format specifier being able to match '.' regardless of
> locale.  Perhaps we should only apply this to HEAD and not back-patch?

The manual claims that 'D' is locale dependent (whereas '.' is not), so
_theoretically_ a back patch would make sense I guess.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Inconsistency between TO_CHAR() and TO_NUMBER()
Следующее
От: Joel Roller
Дата:
Сообщение: Re: BUG #8143: Backend segmentation fault in pg_trgm