Re: Why do indexes and sorts use the database collation?

On Mon, 2023-11-13 at 22:36 +0100, Tomas Vondra wrote:
> Perhaps we could allow the PK index to have a different collation, say
> by supporting something like this:
>
>   ALTER TABLE distributors ADD PRIMARY KEY (dist_id COLLATE "C");

An appealing idea!  While at it, we could add an INCLUDE clause...

The risk here would be extending standard syntax in a way that might
possibly conflict with future changes to the standard.

Yours,
Laurenz Albe