Re: BUG #15805: Problem with lower function for greek sigma (Σ) letter - Mailing list pgsql-bugs

From Daniel Gustafsson
Subject Re: BUG #15805: Problem with lower function for greek sigma (Σ) letter
Date
Msg-id 4F264E45-7708-4CCF-81BE-CE5AF190E71F@yesql.se
Whole thread Raw
In response to Re: BUG #15805: Problem with lower function for greek sigma (Σ) letter  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


Attachment

pgsql-bugs by date:

Previous
From: Richard Yen
Date:
Subject: Re: BUG #15807: pg_upgrade does not account for renaming of systemcatalog column names
Next
From: David Rowley
Date:
Subject: Re: inconsistent results querying table partitioned by date