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 1pgsXj-0007rL-Qq for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Mar 2023 19:30:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pgsWk-0002KT-BX for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Mar 2023 19:29:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pgsM3-0007Xt-Qo for pgsql-bugs@lists.postgresql.org; Mon, 27 Mar 2023 19:18:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pgsM1-0001EM-EA for pgsql-bugs@lists.postgresql.org; Mon, 27 Mar 2023 19:18:06 +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=59d20ZxMLlzkSiZKTqeP+4oUA1ak2d36/4IV800JLJI=; b=53KxcMzpr+oEyivFQ4bA1QdlPp DdvhMMlnPL8j7PH1AiU3Eoq8DweSfMnk/UkE2z1353xkOoRX5yygP8A9t605C9cXv7GvXr3aCP4ax 4WKP+XfJ7aa7bTbQhaOsLrB6TW/ITd/J0RqwTupef3Y8NoksT9Jm10Ca5/8nmGd/FRXDQrL2bV9mN /jgOXclErNNDnpAfgZWVi+vLD4MqrlV9eZwQzSjZno7eCF+nzz8AVKsRqw7n7JYSG90HxHAsp3/BZ +68FMcLoy/vX5lNf6atBfHDovmEgrKRl9U+1XIXJBtq0jJYLzzzRuBQI2SqGKv5YjjUVRYDoD/qZl VaCaCWBw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pgsM1-0002iv-0P for pgsql-bugs@lists.postgresql.org; Mon, 27 Mar 2023 19:18:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pgsLy-0009Ne-L6 for pgsql-bugs@lists.postgresql.org; Mon, 27 Mar 2023 19:18:02 +0000 Content-Type: multipart/mixed; boundary="===============8439035802980043937==" MIME-Version: 1.0 Subject: BUG #17873: Empty JSONB array is ordered before all other JSONB values To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: marcus@cockroachlabs.com Reply-To: marcus@cockroachlabs.com, pgsql-bugs@lists.postgresql.org Date: Mon, 27 Mar 2023 19:17:07 +0000 Message-ID: <17873-826fdc8bbcace4f1@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8439035802980043937== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzg3MwpMb2dnZWQgYnk6ICAgICAgICAgIE1hcmN1cyBHYXJ0bmVyCkVt YWlsIGFkZHJlc3M6ICAgICAgbWFyY3VzQGNvY2tyb2FjaGxhYnMuY29tClBvc3RncmVTUUwgdmVy c2lvbjogMTQuNgpPcGVyYXRpbmcgc3lzdGVtOiAgIG1hY09TIDEzLjIuMQpEZXNjcmlwdGlvbjog ICAgICAgIAoKVGhlIEpTT05CIEluZGV4aW5nIGRvY3VtZW50YXRpb24gKGhlcmU6Cmh0dHBzOi8v d3d3LnBvc3RncmVzcWwub3JnL2RvY3MvMTQvZGF0YXR5cGUtanNvbi5odG1sI0pTT04tSU5ERVhJ TkcpIHN0YXRlcwp0aGF0Og0KDQoiVGhlIGJ0cmVlIG9yZGVyaW5nIGZvciBqc29uYiBkYXR1bXMg aXMgc2VsZG9tIG9mIGdyZWF0IGludGVyZXN0LCBidXQgZm9yCmNvbXBsZXRlbmVzcyBpdCBpczoN Ck9iamVjdCA+IEFycmF5ID4gQm9vbGVhbiA+IE51bWJlciA+IFN0cmluZyA+IE51bGwiDQoNCkhv d2V2ZXIsIHRoZSBlbXB0eSBKU09OQiBhcnJheSB2YWx1ZSBkb2VzIGNvbXBseSB3aXRoIHRoaXMg b3JkZXJpbmcgYXMgaXQgaXMKbGVzcyB0aGFuIGFsbCBvdGhlciBKU09OQiB2YWx1ZXMsIGFzIGZh ciBhcyBJDQpjYW4gdGVsbC4NCg0KU0VMRUNUICdbXSc6OkpTT05CIDwgajo6SlNPTkINCkZST00g KFZBTFVFUw0KICAoJ251bGwnKSwNCiAgKCciYSInKSwNCiAgKCcxJyksDQogICgnWzFdJyksDQog ICgne30nKQ0KKSB2KGopOw0KID9jb2x1bW4/DQotLS0tLS0tLS0tDQogdA0KIHQNCiB0DQogdA0K IHQNCig1IHJvd3MpDQoNCklzIHRoaXMgYSBidWcgaW4gdGhlIEItdHJlZSBvcmRlcmluZyBvZiBK U09OQiB2YWx1ZXM/IEkgY291bGQgbm90IGZpbmQgYW55Cm5vdGVzIGluIHRoZSBzb3VyY2UgY29k ZSBvciB0ZXN0IGNhc2VzIHRoYXQgZXhwbGFpbiB0aGlzDQpzcGVjaWFsIGNhc2UgZm9yIGVtcHR5 IEpTT05CIGFycmF5cy4NCg0KVGhhbmtzLA0KTWFyY3VzCgo= --===============8439035802980043937==--