Re: BUG #15805: Problem with lower function for greek sigma (Σ) letter

Поиск
Список
Период
Сортировка
От Daniel Gustafsson
Тема Re: BUG #15805: Problem with lower function for greek sigma (Σ) letter
Дата
Msg-id 4F264E45-7708-4CCF-81BE-CE5AF190E71F@yesql.se
обсуждение исходный текст
Ответ на Re: BUG #15805: Problem with lower function for greek sigma (Σ) letter  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
> On 15 May 2019, at 17:46, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> "Daniel Verite" <daniel@manitou-mail.org> writes:
>>     PG Bug reporting form wrote:
>>> lower('ΔΗΜΟΤΕΣ ΦΑΙΣΤΟΥ') =
>>> "δημοτεσ φαιστου" instead of "δημοτες φαιστου"
>
>> With PostgreSQL version 10 or newer, you could use an ICU
>> locale. lower() would produce the expected result:
>
> Oh, if using ICU already fixes this, I think we might as well just
> say that you have to use ICU if you want the right behavior for such
> cases.

Seems reasonable.  Maybe it warrants a mention in the docs on the string
function page since it may suprise users?

cheers ./daniel


Вложения

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

Предыдущее
От: Richard Yen
Дата:
Сообщение: Re: BUG #15807: pg_upgrade does not account for renaming of systemcatalog column names
Следующее
От: David Rowley
Дата:
Сообщение: Re: inconsistent results querying table partitioned by date