Re: Explanations not clear - Mailing list pgsql-docs

From Jeff Davis
Subject Re: Explanations not clear
Date
Msg-id 20d80bfbbec3874d430691fec37465fb7c4cb277.camel@j-davis.com
Whole thread Raw
In response to Re: Explanations not clear  (Peter Eisentraut <peter@eisentraut.org>)
Responses Re: Explanations not clear
List pgsql-docs
On Wed, 2024-05-08 at 08:52 +0200, Peter Eisentraut wrote:
> > I created a collation specifying the ks-level3 setting and with
> > deterministic set to false. But when I compare "a_b" to "a-b" with
> > this
> > collation I get false. According to the table 24.1 it should yield
> > true.
> > Only after adding ka-shifted this comparison becomes true. The
> > interactions
> > of the different options are not very clear.
>
> I think table 24.1 is somewhat incorrect in the sense that
> punctuation
> is only level 4 if you use ka-shifted, otherwise it's level 1.  This
> should perhaps be clarified.

One option is to just include 3 levels (plus "identic") in the table,
and then later document that ka-shifted creates a fourth level and
moves punctuation character differences into that level. That explains
the mechanism but detracts from the examples.

Another option is to say that all the examples in the table are using
ka-shifted for illustration purposes. I like this option, but it's a
bit awkward because it refers to something that hasn't been explained
yet. It's also only relevant for the 'x-y' = 'x_y' example, which might
be slightly confusing.

Thoughts?

Regards,
    Jeff Davis




pgsql-docs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Explanations not clear
Next
From: "David G. Johnston"
Date:
Subject: Re: roles that have the CREATEROLE privilege can no longer GRANT predefined roles