Re: EBCDIC sorting as a use case for ICU rules - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: EBCDIC sorting as a use case for ICU rules
Date
Msg-id 620876309e9bda56e7328490d481eb48655d69d3.camel@j-davis.com
Whole thread Raw
In response to Re: EBCDIC sorting as a use case for ICU rules  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
List pgsql-hackers
On Thu, 2023-07-06 at 11:32 +0200, Peter Eisentraut wrote:
> CREATE COLLATION ebcdic (provider='icu', locale='und',
> rules=$$
> & ' ' < '.' < '<' < '(' < '+' < \|
> < '&' < '!' < '$' < '*' < ')' < ';'
> < '-' < '/' < ',' < '%' < '_' < '>' < '?'
> < '`' < ':' < '#' < '@' < \' < '=' < '"'
> < a < b < c < d < e < f < g < h < i
> < j < k < l < m < n < o < p < q < r
> < '~' < s < t < u < v < w < x < y < z
> < '[' < '^' < ']'
> < '{' < A < B < C < D < E < F < G < H < I
> < '}' < J < K < L < M < N < O < P < Q < R
> < '\'  < S < T < U < V < W < X < Y < Z
> < 0 < 1 < 2 < 3 < 4 < 5 < 6 < 7 < 8 < 9
> $$);

That looks much nicer and would go nicely in the documentation along
with some explanation.

Regards,
    Jeff Davis




pgsql-hackers by date:

Previous
From: Gurjeet Singh
Date:
Subject: Re: [PATCH] Add GitLab CI to PostgreSQL
Next
From: Laurenz Albe
Date:
Subject: Re: [PATCH] Add support function for containment operators