On Fri, 2025-09-19 at 17:21 -0700, Jeff Davis wrote:
>
> Proposal
>
>
> New builtin case-insensitive collation PG_UNICODE_CI, where the
> ordering semantics are just:
>
>strcmp(CASEFOLD(arg1), CASEFOLD(arg2))
>
> and the character semantics are the same as PG_UNICODE_FAST.
On Fri, 2025-09-19 at 17:21 -0700, Jeff Davis wrote:
> --
> Versioning
> --
>
> Unlike other built-in collations, the order does depend on the
> version
> of Unicode...
> That means that indexes, including primary keys, can become
> inconsistent after a major version upgrade...
T
Proposal
New builtin case-insensitive collation PG_UNICODE_CI, where the
ordering semantics are just:
strcmp(CASEFOLD(arg1), CASEFOLD(arg2))
and the character semantics are the same as PG_UNICODE_FAST.
This does not perform the Unicode Collation algorithm (UCA), and it is
