Re: Sorting difference in version 10 vs 13 - Mailing list pgsql-general

From Ron
Subject Re: Sorting difference in version 10 vs 13
Date
Msg-id e9b06f2d-99bb-9d23-e800-0282f4031ced@gmail.com
Whole thread Raw
In response to Re: Sorting difference in version 10 vs 13  (Akheel Ahmed <akheel.mailing.list@gmail.com>)
List pgsql-general
Aurora is sufficiently different from vanilla Postgresql that you need to ask Amazon.

On 12/20/21 11:31 PM, Akheel Ahmed wrote:

Both are Amazon AWS Aurora instances. 10.x is on intel/amd64. 13.x is on their ARM based graviton.


select version();
                                                   version
-------------------------------------------------------------------------------------------------------------
 PostgreSQL 13.4 on aarch64-unknown-linux-gnu, compiled by aarch64-unknown-linux-gnu-gcc (GCC) 7.4.0, 64-bit
(1 row)


select version();
                                             version
--------------------------------------------------------------------------------------------------
 PostgreSQL 10.18 on x86_64-pc-linux-gnu, compiled by x86_64-pc-linux-gnu-gcc (GCC) 7.4.0, 64-bit
(1 row)



On 21/12/2021 3:12 pm, Tom Lane wrote:
Akheel Ahmed <akheel.mailing.list@gmail.com> writes:
in 13.4, order by asc gives underscores higher than other characters. 
all the LC parameters are identical across both instances.
Am I missing anything else?
OS-level differences, perhaps?

https://wiki.postgresql.org/wiki/Locale_data_changes
			regards, tom lane

--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: Akheel Ahmed
Date:
Subject: Re: Sorting difference in version 10 vs 13
Next
From: shing dong
Date:
Subject: Re: How to confirm the pg_hba.conf service is correctly working