pgsql: Add standard collation UNICODE

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add standard collation UNICODE
Date: 2023-03-10 12:42:35
Message-ID: E1pac4x-002qVH-Ce@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add standard collation UNICODE

This adds a new predefined collation named UNICODE, which sorts by the
default Unicode collation algorithm specifications, per SQL standard.

This only works if ICU support is built.

Reviewed-by: Jeff Davis <pgsql(at)j-davis(dot)com>
Discussion: https://www.postgresql.org/message-id/flat/1293e382-2093-a2bf-a397-c04e8f83d3c2(at)enterprisedb(dot)com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/0d21d4b9bc1f9da9dda29e5c4db0c6dd45408aaa

Modified Files
--------------
doc/src/sgml/charset.sgml | 31 +++++++++++++++++++++++---
src/bin/initdb/initdb.c | 10 ++++++---
src/include/catalog/catversion.h | 2 +-
src/test/regress/expected/collate.icu.utf8.out | 9 ++++++++
src/test/regress/sql/collate.icu.utf8.sql | 1 +
5 files changed, 46 insertions(+), 7 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2023-03-10 13:29:14 pgsql: Fix tests for non-ICU build
Previous Message Michael Paquier 2023-03-10 11:08:48 pgsql: Include headers of archive/ in installation