Postgres Pro
Downloads
Home   >   mailing lists

Re: Why do indexes and sorts use the database collation? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Why do indexes and sorts use the database collation?
Date
Msg-id 2516190.1699991262@sss.pgh.pa.us
Whole thread Raw
In response to Re: Why do indexes and sorts use the database collation?  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: Why do indexes and sorts use the database collation?
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Implement missing join selectivity estimation for range types
Next
From: Andres Freund
Date:
Subject: Re: pgsql: doc: fix wording describing the checkpoint_flush_after GUC