Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ppwGF-0008W1-7X for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Apr 2023 19:17:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ppwGE-0004XS-3P for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Apr 2023 19:17:34 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ppwGD-0004XI-QS for pgsql-hackers@lists.postgresql.org; Fri, 21 Apr 2023 19:17:33 +0000 Received: from relay11.mail.gandi.net ([2001:4b98:dc4:8::231]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ppwGA-0018C3-Mp for pgsql-hackers@lists.postgresql.org; Fri, 21 Apr 2023 19:17:32 +0000 Received: (Authenticated sender: strk@kbt.io) by mail.gandi.net (Postfix) with ESMTPSA id 948F0100005; Fri, 21 Apr 2023 19:17:26 +0000 (UTC) Date: Fri, 21 Apr 2023 21:17:25 +0200 From: Sandro Santilli Sender: strk@kbt.io To: Jeff Davis Cc: Tom Lane , Regina Obe , pgsql-hackers@lists.postgresql.org Subject: Re: Order changes in PG16 since ICU introduction Message-ID: References: <000b01d97465$c34bbd60$49e33820$@pcorp.us> <3353947.1682092131@sss.pgh.pa.us> <5db89a9f765085f042e1d0ab52a88720f562ee72.camel@j-davis.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <5db89a9f765085f042e1d0ab52a88720f562ee72.camel@j-davis.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Apr 21, 2023 at 10:27:49AM -0700, Jeff Davis wrote: > On Fri, 2023-04-21 at 19:09 +0200, Sandro Santilli wrote: > >   =# select version(); > >   PostgreSQL 16devel on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu > > 11.3.0-1ubuntu1~22.04) 11.3.0, 64-bit > >   =# show lc_collate; > >   C > >   =# select '+' < '-'; > >   f > > What is the result of: > > select datlocprovider, datcollate, daticulocale > from pg_database where datname=current_database(); datlocprovider | i datcollate | C daticulocale | en-US --strk;