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

From Joe Conway
Subject Re: EBCDIC sorting as a use case for ICU rules
Date
Msg-id dc1404b7-b959-a038-13c9-a3c28f91430f@joeconway.com
Whole thread Raw
In response to EBCDIC sorting as a use case for ICU rules  ("Daniel Verite" <daniel@manitou-mail.org>)
List pgsql-hackers
On 6/21/23 09:28, Daniel Verite wrote:
> In the "Order changes in PG16 since ICU introduction" discussion, one
> sub-thread [1] was about having a credible use case for tailoring collations
> with custom rules, a new feature in v16.
> 
> At a conference this week I was asked if ICU could be able to
> sort like EBCDIC [2]. It turns out it has been already    asked on
> -general a few years ago [3] with no satisfactory answer at the time ,
> and that it can be implemented with rules in v16.

Oh, very cool! I have seen the requirement for EBCDIC come up multiple 
times over the years.

<snip>

> Maybe this example could be added to the documentation except for
> the problem that the rule is very long and dollar-quoting cannot be split
> into several lines. Literals enclosed by single quotes can be split that
> way, but would require escaping the single quotes in the rule, which
> would lead to scary-looking over-quoted contents.
> 
> I'm open to suggestions on whether this EBCDIC example is worth being in the
> doc in some form or putting this in the wiki would be good enough.

I would definitely favor adding to the docs, but no idea how to deal 
with the length issue.


-- 
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com




pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Partial aggregates pushdown
Next
From: Nazir Bilal Yavuz
Date:
Subject: Re: bgwriter doesn't flush WAL stats