Re: Order changes in PG16 since ICU introduction

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Regina Obe <lr(at)pcorp(dot)us>, Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>, Sandro Santilli <strk(at)kbt(dot)io>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Order changes in PG16 since ICU introduction
Date: 2023-05-17 03:23:16
Message-ID: 605324592391599a7ecd522087edbd00720793b7.camel@j-davis.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 2023-05-16 at 15:35 -0400, Jonathan S. Katz wrote:
> +          Sensitivity when determining equality, with
> +          <literal>level1</literal> the least sensitive and
> +          <literal>identic</literal> the most sensitive. See <xref
> +          linkend="icu-collation-levels"/> for details.
>
> This discusses equality sensitivity, but I'm not sure if I understand
> that term here. The ICU docs seem to call these "strengths"[1], maybe
> we
> use that term to be consistent with upstream?

"Sensitivity" comes from "case sensitivity" which is more clear to me
than "strength". I added the term "strength" to correspond to the
unicode terminology, but I kept sensitivity and I tried to make it
slightly more clear.

Other than that, and I took your suggestions almost verbatim. Patch
attached. Thank you!

I also made a few other changes:

* added paragraph transformation of '' or 'root' to the 'und'
language (root collation)
* added paragraph that the "identic" level still performs some basic
normalization
* added example for when full normalization matters

I should also say that I don't really understand the case when "kc" is
set to true and "ks" is level 2 or higher. If someone has an example of
where that matters, let me know.

Regards,
Jeff Davis

Attachment Content-Type Size
v2-0001-Doc-improvements-for-language-tags-and-custom-ICU.patch text/x-patch 30.6 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Sjöblom 2023-05-17 04:53:10 Re: [DOC] Update ALTER SUBSCRIPTION documentation v3
Previous Message Pavel Stehule 2023-05-17 03:20:22 Re: Schema variables - new implementation for Postgres 15