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