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

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Daniel Verite <daniel(at)manitou-mail(dot)org>, iksss(dot)88(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15805: Problem with lower function for greek sigma (Σ) letter
Date: 2019-05-15 19:43:51
Message-ID: 4F264E45-7708-4CCF-81BE-CE5AF190E71F@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> On 15 May 2019, at 17:46, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "Daniel Verite" <daniel(at)manitou-mail(dot)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 Content-Type Size
casefolding.diff application/octet-stream 542 bytes

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message David Rowley 2019-05-15 23:53:18 Re: inconsistent results querying table partitioned by date
Previous Message Richard Yen 2019-05-15 18:44:06 Re: BUG #15807: pg_upgrade does not account for renaming of system catalog column names