Re: Collation with upper and numeric comparing in unexpected way - Mailing list pgsql-general

From Matt Magoffin
Subject Re: Collation with upper and numeric comparing in unexpected way
Date
Msg-id 7216E909-5C02-469E-A970-41BEDD4B0242@msqr.us
Whole thread Raw
In response to Re: Collation with upper and numeric comparing in unexpected way  (Peter Eisentraut <peter@eisentraut.org>)
List pgsql-general
On 21 Jan 2026, at 8:52 PM, Peter Eisentraut <peter@eisentraut.org> wrote:
This is just my guess from the outside.  The numeric sorting is not a part of the Unicode Collation Algorithm standard, it is an extension by ICU, so one would have to dig into the code or documentation there, but I didn't find anything.

I don't know if there is a way to customize this further to get the effect you want.  Maybe you could reach out to an ICU support forum to get more expert insights there.

Ah, thank you for your thoughts. I will reach out to the ICU project as you suggest.

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: pgBadger and postgres_fdw
Next
From: Ron Johnson
Date:
Subject: Re: Request for cryptographic mechanisms used in PostgreSQL