Re: Sorting Discrepancy in PostgreSQL 14.13

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: [3반]김민지_4904 <hzuiw33(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: Sorting Discrepancy in PostgreSQL 14.13
Date: 2024-11-20 08:38:21
Message-ID: 1f2d614e-e956-4099-9b57-fba64ed11333@eisentraut.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 14.11.24 13:49, [3반]김민지_4904 wrote:
> as '-' is smaller than '1', or '2' in ascii.
>
> I'm doubtful this is a collation issue, as most collations basically
> respect ASCII order.

See also here for a possible explanation:
https://peter.eisentraut.org/blog/2023/04/12/how-collation-of-punctuation-and-whitespace-works

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Daniel Gustafsson 2024-11-20 09:00:24 Re: Wrong german error message encoding
Previous Message Peter Eisentraut 2024-11-20 08:35:48 Re: Build failure with GCC 15 (defaults to -std=gnu23)