Re: EBCDIC sorting as a use case for ICU rules

Peter Eisentraut <peter@eisentraut.org>

From: Peter Eisentraut <peter@eisentraut.org>
To: Daniel Verite <daniel@manitou-mail.org>, Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Cc: pgsql-hackers@postgresql.org, Jeff Davis <pgsql@j-davis.com>, "Jonathan S. Katz" <jkatz@postgresql.org>
Date: 2023-08-23T09:30:52Z
Lists: pgsql-hackers
On 17.07.23 10:10, Daniel Verite wrote:
> 	Peter Eisentraut wrote:
> 
>> You can use whitespace in the rules.  For example,
>>
>> CREATE COLLATION ebcdic (provider='icu', locale='und',
>> rules=$$
> 
> Nice, it's clearly better that the piece of code I had in the
> previous patch.
> It can also be made more compact by grouping consecutive
> code points, for instance <*a-r for 'a' to 'r'
> I changed it that way, and also moved '^' before '[' and ']',
> since according to [1], '^' is at location 0xB0 and '[' and ']'
> at 0xBA and 0xBB.
> 
> Updated patch attached.

Committed with some editing.  I moved the existing rules example from 
the CREATE COLLATION page into the new section you created, so we have a 
simple example followed by the complex example.




Commits

  1. doc: Add more ICU rules examples