Feedback-ID: i131946ab:Fastmail
Message-ID: <ec13488f-281d-cd15-3c11-afe080f98212@enterprisedb.com>
Date: Thu, 11 May 2023 13:09:26 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0)
 Gecko/20100101 Thunderbird/102.10.1
Subject: Re: Order changes in PG16 since ICU introduction
Content-Language: en-US
To: Jeff Davis <pgsql@j-davis.com>, Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Sandro Santilli <strk@kbt.io>, Tom Lane <tgl@sss.pgh.pa.us>,
 Regina Obe <lr@pcorp.us>, pgsql-hackers@lists.postgresql.org
References: <20230509082553.yjikrxn54mi6hezc@alvherre.pgsql>
 <3a00d1f05299d381dc701d283f95d845c741c6a1.camel@j-davis.com>
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
In-Reply-To: <3a00d1f05299d381dc701d283f95d845c741c6a1.camel@j-davis.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/ec13488f-281d-cd15-3c11-afe080f98212%40enterprisedb.com>
Precedence: bulk

On 09.05.23 17:09, Jeff Davis wrote:
> It's awkward for a user to read pg_database.datlocprovider, then
> depending on that, either look in datcollate or daticulocale. (It's
> awkward in the code, too.)
> 
> Maybe some built-in function that returns a tuple of the default
> provider, the locale, and the version? Or should we also output the
> ctype somehow (which affects the results of upper()/lower())?

There is also the deterministic flag and the icurules setting. 
Depending on what level of detail you imagine the user needs, you really 
do need to look at the whole picture, not some subset of it.