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

Jeff Davis <pgsql@j-davis.com> writes:
> On Tue, 2023-11-14 at 17:15 +0100, Peter Eisentraut wrote:
>> The problem is that the user has no way to declare whether they just 
>> want this.

> We should add a way to declare that a primary key should create an
> index in a particular collation.

Why should that ever be different from the column's own declared
collation?

            regards, tom lane