Message-ID: <3a00d1f05299d381dc701d283f95d845c741c6a1.camel@j-davis.com>
Subject: Re: Order changes in PG16 since ICU introduction
From: Jeff Davis <pgsql@j-davis.com>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>, Peter Eisentraut
	 <peter.eisentraut@enterprisedb.com>
Cc: Sandro Santilli <strk@kbt.io>, Tom Lane <tgl@sss.pgh.pa.us>, Regina Obe
	 <lr@pcorp.us>, pgsql-hackers@lists.postgresql.org
Date: Tue, 09 May 2023 08:09:29 -0700
In-Reply-To: <20230509082553.yjikrxn54mi6hezc@alvherre.pgsql>
References: <20230509082553.yjikrxn54mi6hezc@alvherre.pgsql>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.44.4-0ubuntu1 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/3a00d1f05299d381dc701d283f95d845c741c6a1.camel%40j-davis.com>
Precedence: bulk

On Tue, 2023-05-09 at 10:25 +0200, Alvaro Herrera wrote:
> I agree with removing these in v16, since they are going to become
> more
> meaningless and confusing.

Agreed, but it would be nice to have an alternative that does the right
thing.

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())?

Regards,
	Jeff Davis