Date: Fri, 21 Apr 2023 19:09:14 +0200
From: Sandro Santilli <strk@kbt.io>
Sender: strk@kbt.io
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Regina Obe <lr@pcorp.us>, pgsql-hackers@lists.postgresql.org,
	Jeff Davis <pgsql@j-davis.com>
Subject: Re: Order changes in PG16 since ICU introduction
Message-ID: <ZELDOktA75yYG4Z2@hst.kbt.io>
References: <000b01d97465$c34bbd60$49e33820$@pcorp.us>
 <3353947.1682092131@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <3353947.1682092131@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/ZELDOktA75yYG4Z2%40hst.kbt.io>
Precedence: bulk

On Fri, Apr 21, 2023 at 11:48:51AM -0400, Tom Lane wrote:
> "Regina Obe" <lr@pcorp.us> writes:
> 
> > https://trac.osgeo.org/postgis/ticket/5375
> 
> If they actually are using locale C, I would say this is a bug.
> That should designate memcmp sorting and nothing else.

Sounds like a bug to me. This is happening with a PostgreSQL cluster
created and served by a build of commit c04c6c5d6f :

  =# 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
  =# select '+' < '-' collate "C";
  t

I don't know if it should matter but also:

  =# show lc_messages;
  C

--strk;