Re: ORDER BY DESC / ASC

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Анастасия Лагута <natriksx(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: ORDER BY DESC / ASC
Date: 2021-03-02 09:00:39
Message-ID: 20210302090039.GB16262@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Mar 01, 2021 at 07:52:09PM +0200, Анастасия Лагута wrote:
> There is an issue found while using ORDER BY DESC / ASC, where letter 'w' is before letter 'v'. Should it be that way? Because even
> having a look at the ASCII table, everything should be vice versa.

Without knowing more we can't tell much. What is your locale? Did you
define special collate for database or columns?

Can you show us some sample data, and collate info?

Also, OS and Pg version info might be helpful.

Best regards,

depesz

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2021-03-02 10:34:55 BUG #16909: On update (not insert) the attisdropped flag is set for tables which are recreated with the same col
Previous Message David Rowley 2021-03-02 03:19:24 Re: BUG #16905: Dropping and recreating a large table with 5 indexes slowed down query performance