Re: Sorting difference in version 10 vs 13

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(dot)mailing(dot)list(at)gmail(dot)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.