Re: [DOCS] Failing example for to_number()
| От | David G. Johnston |
|---|---|
| Тема | Re: [DOCS] Failing example for to_number() |
| Дата | |
| Msg-id | CAKFQuwb6JF0LZ1kyUaYDTCTB8F5JfB_gH=6zuy01ysv8nUAM9A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [DOCS] Failing example for to_number() (Erwin Brandstetter <brsaweda@gmail.com>) |
| Список | pgsql-docs |
On top of this (separate issue?) ',' and '.' are ***not*** interpreted according to the current LC_NUMERIC setting. I.e.: even with (example) Austrian locale, ',' still is interpreted as group separator and '.' still is the decimal point.It seems those just follow standard meaning without locale (C locale) - while 'D' and 'G' pattern symbols enforce locale specific format. It took me a while to untangle this and I suspect many people will fail to understand it.
Table 9-26 on that page says "(uses locale)" for D and G, the user is left to deduce that since comma and period do not have that qualifier that they are not locale dependent.
I guess there should be some more explanation.
I don't really agree but I wouldn't discourage someone from submitting a patch.
David J.
В списке pgsql-docs по дате отправления: