Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lH0tc-0001xB-JS for pgsql-bugs@arkaria.postgresql.org; Tue, 02 Mar 2021 09:00:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lH0tb-0002lW-2L for pgsql-bugs@arkaria.postgresql.org; Tue, 02 Mar 2021 09:00:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lH0ta-0002lP-PH for pgsql-bugs@lists.postgresql.org; Tue, 02 Mar 2021 09:00:46 +0000 Received: from lana.depesz.com ([88.198.49.178] helo=depesz.com) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lH0tU-0006tD-ND for pgsql-bugs@lists.postgresql.org; Tue, 02 Mar 2021 09:00:46 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=depesz.com; s=20170201; h=In-Reply-To:Content-Transfer-Encoding:Content-Type: MIME-Version:References:Reply-To:Message-ID:Subject:Cc:To:Sender:From:Date: Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=jnzDO5fOxrlxoqfBkgYXSJp2YcwIh0UHM4ehVOg2g8E=; b=JBXW+Z0ZH9viZZfDrp9QCNqzit jG0548Qj1T5DgfZqdiUKo48x2VoUcQOHWYszIYPBfac2pZl9iYHK3U8ArZjmY1BvHiWx4FVDDnn7T ng/1QQ4dwdp90OExO2NGzHiRkiWigSiGlexNoNocIctqysotB85hX7r2kNC4hmvMCLMY=; Received: from lana.depesz.com ([88.198.49.178] helo=depesz.com) by depesz.com with esmtpa (Exim 4.92) (envelope-from ) id 1lH0tT-0006ZY-3o; Tue, 02 Mar 2021 10:00:39 +0100 Date: Tue, 2 Mar 2021 10:00:39 +0100 From: hubert depesz lubaczewski Sender: depesz@depesz.com To: =?utf-8?B?0JDQvdCw0YHRgtCw0YHQuNGPINCb0LDQs9GD0YLQsA==?= Cc: pgsql-bugs@lists.postgresql.org Subject: Re: ORDER BY DESC / ASC Message-ID: <20210302090039.GB16262@depesz.com> Reply-To: depesz@depesz.com References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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