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 1p4qBf-0007lS-87 for pgsql-committers@arkaria.postgresql.org; Mon, 12 Dec 2022 21:18: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 1p4qBe-0000yS-4W for pgsql-committers@arkaria.postgresql.org; Mon, 12 Dec 2022 21:18:10 +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 1p4qBd-0000gK-Mz for pgsql-committers@lists.postgresql.org; Mon, 12 Dec 2022 21:18:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p4qBZ-0002ti-2k for pgsql-committers@lists.postgresql.org; Mon, 12 Dec 2022 21:18:09 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p4qBX-0004JC-05 for pgsql-committers@lists.postgresql.org; Mon, 12 Dec 2022 21:18:03 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1p4qBV-003GQH-Dn for pgsql-committers@lists.postgresql.org; Mon, 12 Dec 2022 21:18:02 +0000 Content-Type: multipart/mixed; boundary="===============3303812927507737272==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix jsonb subscripting to cope with toasted subscript values. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 12 Dec 2022 21:18:02 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3303812927507737272== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGpzb25iIHN1YnNjcmlwdGluZyB0byBjb3BlIHdpdGggdG9hc3RlZCBzdWJzY3JpcHQgdmFs dWVzLgoKanNvbmJfZ2V0X2VsZW1lbnQoKSB3YXMgaW5jYXV0aW91cyBlbm91Z2ggdG8gdXNlIFZB UkRBVEEoKSBhbmQKVkFSU0laRSgpIGRpcmVjdGx5IG9uIGFuIGFyYml0cmFyeSB0ZXh0IERhdHVt LiAgVGhhdCBvZiBjb3Vyc2UKZmFpbHMgaWYgdGhlIERhdHVtIGlzIHNob3J0LWhlYWRlciwgY29t cHJlc3NlZCwgb3Igb3V0LW9mLWxpbmUuClRoZSB0eXBpY2FsIHJlc3VsdCB3b3VsZCBiZSBmYWls aW5nIHRvIG1hdGNoIGFueSBlbGVtZW50IG9mIGEKanNvbmIgb2JqZWN0LCB0aG91Z2ggbWF0Y2hp bmcgdGhlIHdyb25nIG9uZSBzZWVtcyBwb3NzaWJsZSBhcyB3ZWxsLgoKc2V0UGF0aE9iamVjdCgp IHdhcyBzbGlnaHRseSBicmlnaHRlciwgaW4gdGhhdCBpdCB1c2VkIFZBUkRBVEFfQU5ZCmFuZCBW QVJTSVpFX0FOWV9FWEhEUiwgYnV0IHRoYXQgb25seSBrZXB0IGl0IG91dCBvZiB0cm91YmxlIGZv cgpzaG9ydC1oZWFkZXIgRGF0dW1zLiAgcHVzaF9wYXRoKCkgaGFkIHRoZSBzYW1lIGlzc3VlLiAg VGhpcyBjb3VsZApyZXN1bHQgaW4gZmF1bHR5IHN1YnNjcmlwdGVkIGluc2VydGlvbnMsIHRob3Vn aCBrZXlzIGxvbmcgZW5vdWdoIHRvCmNhdXNlIGEgcHJvYmxlbSBhcmUgbGlrZWx5IHJhcmUgaW4g dGhlIHdpbGQuCgpIYXZpbmcgc2VlbiB0aGVzZSwgSSBsb29rZWQgYXJvdW5kIGZvciB1bnNhZmUg dXNhZ2VzIGluIHRoZSByZXN0Cm9mIHRoZSBhZHQvanNvbiogZmlsZXMuICBUaGVyZSBhcmUgYSBj b3VwbGUgb2YgcGxhY2VzIHdoZXJlIGl0J3Mgbm90CmltbWVkaWF0ZWx5IG9idmlvdXMgdGhhdCB0 aGUgRGF0dW0gY2FuJ3QgYmUgY29tcHJlc3NlZCBvciBvdXQtb2YtbGluZSwKc28gSSBhZGRlZCBw Z19kZXRvYXN0X2RhdHVtX3BhY2tlZCgpIHRvIGNvcGUgaWYgaXQgaXMuICBBbHNvLCByZW1vdmUK c29tZSBvdGhlciB1c2FnZXMgb2YgVkFSREFUQS9WQVJTSVpFIG9uIERhdHVtcyB3ZSBqdXN0IGV4 dHJhY3RlZCBmcm9tCmEgdGV4dCBhcnJheS4gIFRob3NlIGFyZW4ndCBhY3RpdmVseSBicm9rZW4s IGJ1dCB0aGV5IHdpbGwgYmVjb21lIHNvCmlmIHdlIGV2ZXIgc3RhcnQgYWxsb3dpbmcgc2hvcnQt aGVhZGVyIGFycmF5IGVsZW1lbnRzLCB3aGljaCBkb2VzIG5vdApzZWVtIGxpa2UgYSB0ZXJyaWJs eSB1bnJlYXNvbmFibGUgdGhpbmcgdG8gZG8uICBJbiBhbnkgY2FzZSB0aGV5IGFyZQpub3QgZ3Jl YXQgY29kaW5nIGV4YW1wbGVzLCBhbmQgdGhleSBjb3VsZCBhbHNvIGRvIHdpdGggY29tbWVudHMK cG9pbnRpbmcgb3V0IHRoYXQgd2UncmUgYXNzdW1pbmcgd2UgZG9uJ3QgbmVlZCBwZ19kZXRvYXN0 X2RhdHVtX3BhY2tlZC4KClBlciByZXBvcnQgZnJvbSBleGUtZGVhbGVyQHlhbmRleC5ydS4gIFBh dGNoIGJ5IG1lLCBidXQgdGhhbmtzIHRvCkRhdmlkIEpvaG5zdG9uIGZvciBpbml0aWFsIGludmVz dGlnYXRpb24uICBCYWNrLXBhdGNoIHRvIHYxNCB3aGVyZQpqc29uYiBzdWJzY3JpcHRpbmcgd2Fz IGludHJvZHVjZWQuCgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzIwNTMyMTY3MDYx NTk1M0BtYWlsLnlhbmRleC5ydQoKQnJhbmNoCi0tLS0tLQpSRUxfMTVfU1RBQkxFCgpEZXRhaWxz Ci0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9kNzliNzZi MTBlZDU1Y2ViMjUzNzdjMDYyM2YyYTE1OWFkNjExN2I0CgpNb2RpZmllZCBGaWxlcwotLS0tLS0t LS0tLS0tLQpzcmMvYmFja2VuZC91dGlscy9hZHQvanNvbmJfZ2luLmMgICB8ICA1ICsrKy0tCnNy Yy9iYWNrZW5kL3V0aWxzL2FkdC9qc29uYl9vcC5jICAgIHwgMTAgKysrKystLS0tCnNyYy9iYWNr ZW5kL3V0aWxzL2FkdC9qc29uZnVuY3MuYyAgIHwgNDEgKysrKysrKysrKysrKysrKysrKysrKysr KystLS0tLS0tLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2pzb25iLm91dCB8IDM0ICsr KysrKysrKysrKysrKysrKysrKysrKysrKysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9qc29uYi5z cWwgICAgICB8IDE4ICsrKysrKysrKysrKysrKysKNSBmaWxlcyBjaGFuZ2VkLCA5MCBpbnNlcnRp b25zKCspLCAxOCBkZWxldGlvbnMoLSkKCg== --===============3303812927507737272==--