| From: | Peter Eisentraut <peter(at)eisentraut(dot)org> |
|---|---|
| To: | Daniel Verite <daniel(at)manitou-mail(dot)org>, Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, Jeff Davis <pgsql(at)j-davis(dot)com>, "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org> |
| Subject: | Re: EBCDIC sorting as a use case for ICU rules |
| Date: | 2023-08-23 09:30:52 |
| Message-ID: | 34455279-3b78-f164-7260-1b442ce3b07e@eisentraut.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | shveta malik | 2023-08-23 10:07:59 | Re: Synchronizing slots from primary to standby |
| Previous Message | torikoshia | 2023-08-23 09:04:18 | Re: pg_rewind WAL segments deletion pitfall |