On 2020-12-04 17:18, Tom Lane wrote:
>> There is a SET COLLATION command in the SQL standard that does this.
>> Someone just has to implement it. It wouldn't be terribly difficult, I
>> think.
>
> [ squint... ] Just because it's in the standard doesn't mean it's a
> good idea. It sounds like this is morally equivalent to a GUC that
> changes query semantics. We have learned painfully that such behaviors
> are best avoided, because they break things you didn't expect to break.
I think it would be analogous to the schema search path.