Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1rf3j1-00FB51-EA
	for pgsql-bugs@arkaria.postgresql.org; Tue, 27 Feb 2024 20:06:52 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1rf3iz-005sCy-QK
	for pgsql-bugs@arkaria.postgresql.org; Tue, 27 Feb 2024 20:06:50 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <noreply@postgresql.org>)
	id 1rf1lO-004dGl-IX
	for pgsql-bugs@lists.postgresql.org; Tue, 27 Feb 2024 18:01:11 +0000
Received: from mahout.postgresql.org ([2001:4800:3e1:1::227])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <noreply@postgresql.org>)
	id 1rf1lI-001Ywd-6L
	for pgsql-bugs@lists.postgresql.org; Tue, 27 Feb 2024 18:01:09 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed;
	d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject:
	MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID:
	Content-Description:In-Reply-To:References;
	bh=1FX6NayAYh8p3je4ClRMkyl6Y67IpplMJ8xxiKBf7Ro=; b=QbKaISd1JDVJwEZ/EM6y5Y5AkI
	4ikrwPQkp8FMAio5ryLZSIMbabYbZgrLy00gi0pgx7p5TStOwPkeLV220IIt9VHkpLgnS03SCYzzw
	4AHiR3boqT+A2yJvDZPFhH2Au2UkfPUvnFfWBgzuRChssxumxUjDKqTohO5/1Yun9a69ERUoSSf9g
	g0k/Yn1FTDaTjGffmrKehl6FoQRBcACOLUTj7Ll/i+UpI/EV11q5jE8yZkqYcTmkk8xlh4Z/fw6pF
	3kzcdVr3ci09FgDEzwv5zX+/NQqXJo8p1t6P+XNfJU2vjWAzMmZOJWrI53x4FDCt5njoieJDXkMe3
	7yJYxQrw==;
Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34])
	by mahout.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <noreply@postgresql.org>)
	id 1rf1lI-003dPw-2H
	for pgsql-bugs@lists.postgresql.org; Tue, 27 Feb 2024 18:01:04 +0000
Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org)
	by wrigleys.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <noreply@postgresql.org>)
	id 1rf1lG-0099kX-91
	for pgsql-bugs@lists.postgresql.org; Tue, 27 Feb 2024 18:01:03 +0000
Content-Type: multipart/mixed; boundary="===============4930397248576322249=="
MIME-Version: 1.0
Subject: BUG #18368: order by collation doesn't work as expected for the
 second column in the ORDER BY list
To: pgsql-bugs@lists.postgresql.org
From: PG Bug reporting form <noreply@postgresql.org>
Cc: octavian@codrut-popescu.com
Reply-To: octavian@codrut-popescu.com, pgsql-bugs@lists.postgresql.org
Date: Tue, 27 Feb 2024 18:00:17 +0000
Message-ID: <18368-000eb75b438d3b72@postgresql.org>
X-Auto-Response-Suppress: All
Auto-Submitted: auto-generated
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/18368-000eb75b438d3b72%40postgresql.org>
Precedence: bulk

--===============4930397248576322249==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: base64

VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl
ZmVyZW5jZTogICAgICAxODM2OApMb2dnZWQgYnk6ICAgICAgICAgIE9jdGF2aWFuLUNvZHJ1dCBQ
b3Blc2N1CkVtYWlsIGFkZHJlc3M6ICAgICAgb2N0YXZpYW5AY29kcnV0LXBvcGVzY3UuY29tClBv
c3RncmVTUUwgdmVyc2lvbjogMTYuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0
aW9uOiAgICAgICAgCgpjb2RydXQ9IyBjcmVhdGUgY29sbGF0aW9uIGdlcm1hbl9jdXN0b21fY29k
cnV0KHByb3ZpZGVyID0gaWN1LCBsb2NhbGUgPQonZGVfREUudXRmOEBjb2xSZW9yZGVyPWxhdG4t
ZGlnaXQnKTsNCk5PVElDRTogIHVzaW5nIHN0YW5kYXJkIGZvcm0gImRlLURFLXUta3ItbGF0bi1k
aWdpdCIgZm9yIElDVSBsb2NhbGUKImRlX0RFLnV0ZjhAY29sUmVvcmRlcj1sYXRuLWRpZ2l0Ig0K
Q1JFQVRFIENPTExBVElPTg0KY29kcnV0PSMgDQpjb2RydXQ9IyANCmNvZHJ1dD0jIHdpdGggdiAo
YSwgYikgYXMgKHZhbHVlcyAoJzgzMDAwMDAzJywgJzEyM2FiYycpLCAoJzgzMDAwMDAzJywKJ2Fi
YzEyMycpLCAoJzgzMDAwMDA0JywgJ0FCQzEyMycpKQ0KY29kcnV0LSMgc2VsZWN0IGEsYiBmcm9t
IHYgb3JkZXIgYnkgYSwgYiBjb2xsYXRlICJnZXJtYW5fY3VzdG9tX2NvZHJ1dCI7DQogICAgYSAg
ICAgfCAgIGIgICAgDQotLS0tLS0tLS0tKy0tLS0tLS0tDQogODMwMDAwMDMgfCAxMjNhYmMNCiA4
MzAwMDAwMyB8IGFiYzEyMw0KIDgzMDAwMDA0IHwgQUJDMTIzDQooMyByb3dzKQ0KDQpjb2RydXQ9
IyB3aXRoIHYgKGEsIGIpIGFzICh2YWx1ZXMgKCc4MzAwMDAwMycsICcxMjNhYmMnKSwgKCc4MzAw
MDAwMycsCidhYmMxMjMnKSwgKCc4MzAwMDAwNCcsICdBQkMxMjMnKSkNCmNvZHJ1dC0jIHNlbGVj
dCBhLGIgZnJvbSB2IHdoZXJlIGEgPSAnODMwMDAwMDMnIG9yZGVyIGJ5IGEsIGIgY29sbGF0ZQoi
Z2VybWFuX2N1c3RvbV9jb2RydXQiOw0KICAgIGEgICAgIHwgICBiICAgIA0KLS0tLS0tLS0tLSst
LS0tLS0tLQ0KIDgzMDAwMDAzIHwgYWJjMTIzDQogODMwMDAwMDMgfCAxMjNhYmMNCigyIHJvd3Mp
DQoNCmNvZHJ1dD0jIHNlbGVjdCB2ZXJzaW9uKCk7DQogICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHZlcnNpb24gICAgICAgCiAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCi0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLQ0KIFBvc3RncmVTUUwgMTYuMiAoUG9zdGdyZXMuYXBwKSBvbiBhYXJjaDY0
LWFwcGxlLWRhcndpbjIxLjYuMCwgY29tcGlsZWQgYnkKQXBwbGUgY2xhbmcgdmVyc2lvbiAxNC4w
LjAgKGNsYW5nLTE0MDAuMC4yOS4xMDIpLCA2NC1iaXQNCigxIHJvdykNCg0KYmFzaWNhbGx5IGp1
c3QgaW50cm9kdWNpbmcgb3IgcmVtb3Zpbmcgd2hlcmUgYSA9ICc4MzAwMDAwMycgY2hhbmdlcyB0
aGUKT1JERVIgQlkgYmVoYXZpb3IuCgo=

--===============4930397248576322249==--