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 1oQXYL-0004gP-Do for pgsql-hackers@arkaria.postgresql.org; Tue, 23 Aug 2022 17:19:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oQXYK-0000rb-AQ for pgsql-hackers@arkaria.postgresql.org; Tue, 23 Aug 2022 17:19:00 +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 1oQXYK-0000rR-05 for pgsql-hackers@lists.postgresql.org; Tue, 23 Aug 2022 17:19:00 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oQXYH-0002aQ-Ab for pgsql-hackers@lists.postgresql.org; Tue, 23 Aug 2022 17:18:59 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:In-Reply-To:Subject:From: References:Cc:To:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=hP5zD3h6kwQBnmrE3ETkVRY7OPobe1UMIXA5spSou+k=; b=Hu2YtUXTaEep1aXgNJT7ccEb8t DufU1+ZYYNK+s3ZDhO5UFg/WfJxi6yD/Kj863rooKOd2sYzXL1sFAJN2MshJnXldy0WbErkRuPbhZ PQK/Rl2rZMPo5sPT/vlpAkMejxI3RFuCSM57EomiMHI1ks88qra4aZaU2We53SP4Sg9fKTvj9P1tp P4YNR+WudOdITq8KIUZXV4oIJBqiyPscaPoAjTWLkBxLx6qL9C0S2kthr/8efW0gCrOTutCIR/Z6D f/Kcrbe4Dmp0OQq2U2f8NUhLXT5Gk/4Bc5Bacb7q/YPK8e0wqOxPS3twqhBrYUDKjV/bQ5dXHXiDf WYx8PdSg==; Received: from [52.119.84.106] (helo=[192.168.88.177]) by meldrar.postgresql.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oQXYC-0003Z4-V8; Tue, 23 Aug 2022 17:18:55 +0000 Message-ID: <35468585-e18f-3be6-a228-4ec478f796ac@postgresql.org> Date: Tue, 23 Aug 2022 13:18:49 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Thunderbird/91.12.0 Content-Language: en-US To: Tom Lane , Robert Haas Cc: Nikita Glukhov , Andres Freund , PostgreSQL Hackers , Andrew Dunstan , Michael Paquier , John Naylor , Amit Langote References: <20220815223853.itrlpqgpqheg6r6a@awork3.anarazel.de> <225d341b-f310-eed0-ceff-b8ec61669d9f@postgrespro.ru> <20220816021425.5sa6gx67zmpou3bc@awork3.anarazel.de> <8d0ffc54-469a-ffab-68a3-8b547e24a08d@postgresql.org> <7d83684b-7932-9f29-400b-0beedfafcdd4@postgrespro.ru> <69022273-e7e3-6d1a-10f8-d1b4740e4b97@postgresql.org> <92cab50c-152b-84fc-fd49-12b936113a3d@postgresql.org> <692364.1661267311@sss.pgh.pa.us> From: "Jonathan S. Katz" Subject: Re: SQL/JSON features for v15 In-Reply-To: <692364.1661267311@sss.pgh.pa.us> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------XcAEj1izds5A5kklFXMSwp0G" X-Host-Lookup-Failed: Reverse DNS lookup failed for 52.119.84.106 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------XcAEj1izds5A5kklFXMSwp0G Content-Type: multipart/mixed; boundary="------------0gEWdv3ktbVCK02nSOlJJGTc"; protected-headers="v1" From: "Jonathan S. Katz" To: Tom Lane , Robert Haas Cc: Nikita Glukhov , Andres Freund , PostgreSQL Hackers , Andrew Dunstan , Michael Paquier , John Naylor , Amit Langote Message-ID: <35468585-e18f-3be6-a228-4ec478f796ac@postgresql.org> Subject: Re: SQL/JSON features for v15 References: <20220815223853.itrlpqgpqheg6r6a@awork3.anarazel.de> <225d341b-f310-eed0-ceff-b8ec61669d9f@postgrespro.ru> <20220816021425.5sa6gx67zmpou3bc@awork3.anarazel.de> <8d0ffc54-469a-ffab-68a3-8b547e24a08d@postgresql.org> <7d83684b-7932-9f29-400b-0beedfafcdd4@postgrespro.ru> <69022273-e7e3-6d1a-10f8-d1b4740e4b97@postgresql.org> <92cab50c-152b-84fc-fd49-12b936113a3d@postgresql.org> <692364.1661267311@sss.pgh.pa.us> In-Reply-To: <692364.1661267311@sss.pgh.pa.us> --------------0gEWdv3ktbVCK02nSOlJJGTc Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOC8yMy8yMiAxMTowOCBBTSwgVG9tIExhbmUgd3JvdGU6DQo+IFJvYmVydCBIYWFzIDxy b2JlcnRtaGFhc0BnbWFpbC5jb20+IHdyaXRlczoNCj4+IEF0IHRoZSBlbmQgb2YgdGhlIGRh eSwgdGhlIFJNVCBpcyBnb2luZyB0byBoYXZlIHRvIHRha2UgYSBjYWxsIGhlcmUuDQo+PiBJ dCBzZWVtcyB0byBtZSB0aGF0IEFuZHJlcydzIGNvbmNlcm5zIGFib3V0IGNvZGUgcXVhbGl0 eSBhbmQgbGFjayBvZg0KPj4gY29tbWVudHMgYXJlIHByb2JhYmx5IHNvbWV3aGF0IGxlZ2l0 aW1hdGUsIGFuZCBpbiBwYXJ0aWN1bGFyIEkgZG8gbm90DQo+PiB0aGluayB0aGUgdXNlIG9m IHN1YnRyYW5zYWN0aW9ucyBpcyBhIGdvb2QgaWRlYS4gSSBhbHNvIGRvbid0IHRoaW5rDQo+ PiB0aGF0IHRyeWluZyB0byBmaXggdGhvc2UgcHJvYmxlbXMgb3IgZ2VuZXJhbGx5IGltcHJv dmUgdGhlIGNvZGUgYnkNCj4+IGNvbW1pdHRpbmcgdGhvdXNhbmRzIG9mIGxpbmVzIG9mIG5l dyBjb2RlIGluIEF1Z3VzdCB3aGVuIHdlJ3JlDQo+PiB0YXJnZXRpbmcgYSByZWxlYXNlIGlu IFNlcHRlbWJlciBvciBPY3RvYmVyIGlzIG5lY2Vzc2FyaWx5IGEgZ29vZA0KPj4gaWRlYS4g QnV0IEknbSBhbHNvIG5vdCBpbiBhIHBvc2l0aW9uIHRvIHNheSB0aGF0IHRoZSBwcm9qZWN0 IGlzIGdvaW5nDQo+PiB0byBiZSBpcnJlcGFyYWJseSBkYW1hZ2VkIGlmIHdlIGp1c3Qgc2hp cCB3aGF0IHdlJ3ZlIGdvdCwgcGVyaGFwcw0KPj4gYWZ0ZXIgZml4aW5nIHRoZSBtb3N0IGFj dXRlIHByb2JsZW1zIHRoYXQgd2UgY3VycmVudGx5IGtub3cgYWJvdXQuDQo+IA0KPiBUaGUg cHJvYmxlbSBoZXJlIGlzIHRoYXQgdGhpcyB3YXMgZ29pbmcgdG8gYmUgYSBoZWFkbGluZSBu ZXcgZmVhdHVyZQ0KPiBmb3IgdjE1LiAgU2hpcHBpbmcgd2hhdCBhcHBhcmVudGx5IGlzIG9u bHkgYW4gYWxwaGEtcXVhbGl0eSBpbXBsZW1lbnRhdGlvbg0KPiBzZWVtcyBwcmV0dHkgcHJv YmxlbWF0aWMgdW5sZXNzIHdlIGFkdmVydGlzZSBpdCBhcyBzdWNoLCBhbmQgdGhhdCdzDQo+ IG5vdCBzb21ldGhpbmcgd2UndmUgZG9uZSB2ZXJ5IG11Y2ggaW4gdGhlIHBhc3QuIA0KDQpX aXRoIG15IHVzZXIgaGF0IG9uLCB3ZSBoYXZlIGRvbmUgdGhpcyBiZWZvcmUgLS0gaWYgaW5h ZHZlcnRlbnRseSAtLSBidXQgDQphZ3JlZSBpdCdzIG5vdCByZWNvbW1lbmRlZCBub3IgYSBo YWJpdCB3ZSBzaG91bGQgZ2V0IGludG8uDQoNCj4gQXMgeW91IHNheSwgd2UndmUgZGVsZWdh dGVkIHRoaXMgc29ydCBvZiBkZWNpc2lvbiB0byB0aGUgUk1ULCBidXQNCj4gaWYgSSB3ZXJl IG9uIHRoZSBSTVQgSSdkIGJlIHZvdGluZyB0byByZXZlcnQuDQoNCldpdGggUk1UIGhhdCBv bix0aGUgUk1UIGRvZXMgaGF2ZSBwb3dlciBvZiBmb3JjZWQgY29tbWl0L3JldmVydCBpbiAN CmFic2VuY2Ugb2YgY29uc2Vuc3VzIHRocm91Z2ggcmVndWxhciBjb21tdW5pdHkgcHJvY2Vz c2VzWzFdLiBXZSBkaWQgDQpleHBsaWNpdGx5IGRpc2N1c3MgYXQgb3VyIG1lZXRpbmcgdG9k YXkgaWYgd2Ugd2VyZSBnb2luZyB0byBtYWtlIHRoZSANCmRlY2lzaW9uIHJpZ2h0IG5vdy4g V2UgZGVjaWRlZCB0aGF0IHdlIHdvdWxkIGNvbWUgYmFjayBhbmQgc2V0IGEgDQpkZWFkbGlu ZSBvbiBsZXR0aW5nIHRoZSBjb21tdW5pdHkgcHJvY2Vzc2VzIHBsYXkgb3V0LCBvdGhlcndp c2Ugd2Ugd2lsbCANCm1ha2UgdGhlIGRlY2lzaW9uLg0KDQpGb3IgZGVjaXNpb24gZGVhZGxp bmU6IGlmIHRoZXJlIGlzIG5vIGNvbW11bml0eSBjb25zZW5zdXMgYnkgZW5kIG9mIEF1ZyAN CjI4LCAyMDIyIEFvRSwgdGhlIFJNVCB3aWxsIG1ha2UgdGhlIGRlY2lzaW9uLiBJIGtub3cg QW5kcmV3IGhhcyBiZWVuIA0KcHJlcHBpbmcgZm9yIHRoZSBvdXRjb21lIG9mIGEgcmV2ZXJ0 IC0tIHRoaXMgc2hvdWxkIGdpdmUgZW5vdWdoIGZvciANCnJldmlldyBhbmQgbWVyZ2UgcHJp b3IgdG8gYSBCZXRhIDQgcmVsZWFzZSAodGFyZ2V0ZWQgZm9yIFNlcCA4KS4gSWYgDQp0aGVy ZSBpcyBjb25jZXJuIGFib3V0IHRoYXQsIHRoZSBSTVQgY2FuIG1vdmUgdXAgdGhlIGRlY2lz aW9uIHRpbWVmcmFtZS4NCg0KVGFraW5nIFJNVCBoYXQgb2ZmLCBpZiB0aGUgb3V0Y29tZSBp cyAicmV2ZXJ0IiwgSSBkbyB3YW50IHRvIGVuc3VyZSB3ZSANCmRvbid0IGxvc2UgbW9tZW50 dW0gb24gZ2V0dGluZyB0aGlzIGludG8gdjE2LiBJIGtub3cgYSBsb3Qgb2YgdGltZSBhbmQg DQplZmZvcnQgaGFzIGdvbmUgaW50byB0aGlzIGZlYXR1cmVzZXQgYW5kIGl0IHNlZW1zIHRv IGJlIHRyZW5kaW5nIGluIHRoZSANCnJpZ2h0IGRpcmVjdGlvbi4gV2UgaGF2ZSBhIG1peGVk IGhpc3Rvcnkgb24gcmV2ZXJ0cyBpbiB0ZXJtcyBvZiBpZi93aGVuIA0KdGhleSBhcmUgY29t bWl0dGVkIGFuZCBJIGRvbid0IHdhbnQgdG8gc2VlIHRoYXQgaGFwcGVuIHRvIHRoZXNlIA0K ZmVhdHVyZXMuIEkgZG8gdGhpbmsgdGhpcyB3aWxsIHJlbWFpbiBhIGhlYWRsaW5lIGZlYXR1 cmUgZXZlbiBpZiB3ZSANCmRlbGF5IGl0IGZvciB2MTYuDQoNCkkgc2F3IEFuZHJldyBzdWdn ZXN0IHRoYXQgdGhlIGNvbnRyb3ZlcnNpYWwgcGFydHMgb2YgdGhlIHBhdGNoc2V0IG1heSBi ZSANCnNldmVyYWJsZSBmcm9tIHNvbWUgb2YgdGhlIG5ldyBmdW5jdGlvbmFsaXR5LCBzbyBJ IHdvdWxkIGxpa2UgdG8gc2VlIA0KdGhhdCBwcm9wb3NhbCBhbmQgaWYgaXQgaXMgZW5vdWdo IHRvIG92ZXJjb21lIGNvbmNlcm5zLg0KDQpUaGFua3MsDQoNCkpvbmF0aGFuDQoNClsxXSBo dHRwczovL3dpa2kucG9zdGdyZXNxbC5vcmcvd2lraS9SZWxlYXNlX01hbmFnZW1lbnRfVGVh bQ0K --------------0gEWdv3ktbVCK02nSOlJJGTc-- --------------XcAEj1izds5A5kklFXMSwp0G Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wsF5BAABCAAjFiEE+oS2la8r95ogZD/x8QSccp8cZScFAmMFC/kFAwAAAAAACgkQ8QSccp8cZScc 9g//ZRjxZ6gZmhSQCiDdKjNZTFWDCDqZ2Gqbmkfaq1KfwpNHv9cbq5PVo9Bhmq7y4nL9kV2Lzg3R k+x6ZCUNt0ako8Mvz7UF+12b/TVKYptkopZqniEd0rWL3oXwzMflwnufz7yHhzNRa08I+00hnOaI TlyMEKV/qgrVSm9uaKpWXrhLhvEFTtJyOUE0bEo1IdGTwJnitKArpKPOylauySUvc/APls1lbdJK 5I6oFBiee/4Z1L/pQ2lvfDE9eC4pbFQLZXIBTKceT14dDr1YkHHxjlLGhJLJPMqFCHsPXGNhyIZl 9bvJL7g4lwkmn70XnCXn4JeO+UHHyTlOVKejDix3ZQwPUvq5FwCQjDhXTJklFX7G1wMWQzjG4zjy gexrJjNNpViXqhad/ysRQX3s+W1OmBqmbcIii2NdfyjD+fcelOiGAhj58May+lvIu+C3e2USuSmO eFacQ89PUxShUgSSDqmE7vZFKzd4CTPGWhu6IyQgG4zaQ6uvJx34kEfKG4Vv1peP/xpZCntOaHSD LvpeoSaNEh85/FohaeG9jfApYJmTX0J/a27S+c5z/gqPthS9Lv+dMHPBl4IdJDQZm7PWpz2ymcYK Sg05olHhrS3FvZ6FeFEt5WCDk1056aO9GDmPc4ikSK9uHTL4H6rPpcxrqD8SNCwWKgqtfvfa90xe H7s= =MhY2 -----END PGP SIGNATURE----- --------------XcAEj1izds5A5kklFXMSwp0G--