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 1oRyj4-0002Yu-FM for pgsql-hackers@arkaria.postgresql.org; Sat, 27 Aug 2022 16:32:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oRyi4-0007OJ-Nk for pgsql-hackers@arkaria.postgresql.org; Sat, 27 Aug 2022 16:31:00 +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 1oRyi4-0007OA-5x for pgsql-hackers@lists.postgresql.org; Sat, 27 Aug 2022 16:31:00 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oRyi1-0003fq-5I for pgsql-hackers@lists.postgresql.org; Sat, 27 Aug 2022 16:30: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=EL7N3nSg7fZllANBSDLZmchXKSwp0ckY8//KvEOtbfs=; b=5VXaU7sOR9xtBVMmiGOMuB/YNb 5L/MVwc3tBAGajamXOyB8JDGT8VbUn1xKu1KfuqQAhvqJm4gXnjdvQmYBwquk+Jjdq2+a8COaot4Z TM9p1X3qebS4zcaemdvzUFzp83k2o4buF4mAeSA1eXdPI6Hen8ibh0mK6Z+2BJmtE1R5oRBBOumk6 VdyuNz5uWb6g7599H+uNqYLyBjAHOJHGO/PGWP+yva7brnptRBVYGmIFCAC/e5gcaUCcgYE8JpECz Ffl273EC7kbNr6B5F9oiSG8TNA2CD138OWRA0Sg/GoVHiaFA211KHpWMTDJLwbXVlaTleYRTxzAKt rfFBlo3g==; 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 1oRyhu-0008EQ-8m; Sat, 27 Aug 2022 16:30:52 +0000 Message-ID: <447324f2-d7f5-5d43-4c0a-6f2e6de30c54@postgresql.org> Date: Sat, 27 Aug 2022 12:30:43 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Thunderbird/91.13.0 Content-Language: en-US To: Andrew Dunstan , Nikita Glukhov , Tom Lane Cc: Robert Haas , Andres Freund , PostgreSQL Hackers , Michael Paquier , John Naylor , Amit Langote References: <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> <35468585-e18f-3be6-a228-4ec478f796ac@postgresql.org> <716936.1661275451@sss.pgh.pa.us> <3596205e-ce1e-6959-7559-6ddd67f8294b@postgrespro.ru> <3f8d4c2b-1e58-bf19-580e-64e9755897ef@postgrespro.ru> <072a47f0-7a39-2266-5f90-1178a3860be1@dunslane.net> <1992b190-f00b-8435-b561-e3c6ac450482@postgresql.org> <59660a0b-7b7a-75ab-75c4-b6d53fbda5f6@dunslane.net> <6ba7ba7b-9fdd-674f-c227-59a59e0de1ec@postgrespro.ru> <9e182b2c-1069-4356-1de4-b6b804507b8f@dunslane.net> From: "Jonathan S. Katz" Subject: Re: SQL/JSON features for v15 In-Reply-To: <9e182b2c-1069-4356-1de4-b6b804507b8f@dunslane.net> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------500vUlDhpNyv6Lm5AIEkchOX" 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) --------------500vUlDhpNyv6Lm5AIEkchOX Content-Type: multipart/mixed; boundary="------------gFTaEEL7B6VtSgE2Y2BfYVVZ"; protected-headers="v1" From: "Jonathan S. Katz" To: Andrew Dunstan , Nikita Glukhov , Tom Lane Cc: Robert Haas , Andres Freund , PostgreSQL Hackers , Michael Paquier , John Naylor , Amit Langote Message-ID: <447324f2-d7f5-5d43-4c0a-6f2e6de30c54@postgresql.org> Subject: Re: SQL/JSON features for v15 References: <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> <35468585-e18f-3be6-a228-4ec478f796ac@postgresql.org> <716936.1661275451@sss.pgh.pa.us> <3596205e-ce1e-6959-7559-6ddd67f8294b@postgrespro.ru> <3f8d4c2b-1e58-bf19-580e-64e9755897ef@postgrespro.ru> <072a47f0-7a39-2266-5f90-1178a3860be1@dunslane.net> <1992b190-f00b-8435-b561-e3c6ac450482@postgresql.org> <59660a0b-7b7a-75ab-75c4-b6d53fbda5f6@dunslane.net> <6ba7ba7b-9fdd-674f-c227-59a59e0de1ec@postgrespro.ru> <9e182b2c-1069-4356-1de4-b6b804507b8f@dunslane.net> In-Reply-To: <9e182b2c-1069-4356-1de4-b6b804507b8f@dunslane.net> --------------gFTaEEL7B6VtSgE2Y2BfYVVZ Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOC8yNi8yMiA0OjM2IFBNLCBBbmRyZXcgRHVuc3RhbiB3cm90ZToNCj4gDQo+IE9uIDIw MjItMDgtMjYgRnIgMTY6MTEsIE5pa2l0YSBHbHVraG92IHdyb3RlOg0KPj4NCj4+IEhpLA0K Pj4NCj4+IE9uIDI2LjA4LjIwMjIgMjI6MjUsIEFuZHJldyBEdW5zdGFuIHdyb3RlOg0KPj4+ IE9uIDIwMjItMDgtMjQgV2UgMjA6MDUsIE5pa2l0YSBHbHVraG92IHdyb3RlOg0KPj4+PiB2 OCAtIGlzIGEgaGlnaGx5IFdJUCBwYXRjaCwgd2hpY2ggSSBmYWlsZWQgdG8gZmluaXNoIHRv ZGF5Lg0KPj4+PiBFdmVuIHNvbWUgdGVzdCBjYXNlcyBmYWlsIG5vdywgYW5kIHRoZXkgc2lt cGx5IHNob3cgdW5maW5pc2hlZA0KPj4+PiB0aGluZ3MgbGlrZSBjYXN0cyB0byBieXRlYSAo dGhleSBjYW4gYmUgc2ltcGx5IHJlbW92ZWQpIGFuZCBtaXNzaW5nDQo+Pj4+IHNhZmUgaW5w dXQgZnVuY3Rpb25zLg0KPj4+IFRoYW5rcyBmb3IgeW91ciB3b3JrLCBwbGVhc2Uga2VlcCBn b2luZy4NCj4+IEkgaGF2ZSBjb21wbGV0ZWQgaW4gdjkgYWxsIHRoZSB0aGluZ3MgSSBwcmV2 aW91c2x5IHBsYW5uZWQ6DQo+Pg0KPj4gICAtIEFkZGVkIG1pc3Npbmcgc2FmZSBJL08gYW5k IHR5cGUgY29udmVyc2lvbiBmdW5jdGlvbnMgZm9yDQo+PiAgICAgZGF0ZXRpbWUsIGZsb2F0 NCwgdmFyY2hhciwgYnBjaGFyLiAgVGhpcyBpbnRyb2R1Y2VzIGEgbG90DQo+PiAgICAgb2Yg Ym9pbGVycGxhdGUgY29kZSBmb3IgcmV0dXJuaW5nIGVycm9ycyBhbmQgYWxzbyBtYXliZQ0K Pj4gICAgIGFkZHMgc29tZSBvdmVyaGVhZC4NCj4+DQo+PiAgIC0gQWRkZWQgSlNPTl9RVUVS WSBjb2VyY2lvbiB0byBVVEY4IGJ5dGVhIHVzaW5nIHBnX2NvbnZlcnRfdG8oKS4NCj4+DQo+ PiAgIC0gQWRkZWQgaW1tdXRhYmlsaXR5IGNoZWNrcyB0aGF0IHdlcmUgbWlzc2VkIHdpdGgg ZWxpbWluYXRpb24NCj4+ICAgICBvZiBjb2VyY2lvbiBleHByZXNzaW9ucy4NCj4+ICAgICBD b2VyY2lvbnMgdGV4dDo6ZGF0ZXRpbWUsIGRhdGV0aW1lMTo6ZGF0ZXRpbWUyIGFuZCBldmVu DQo+PiAgICAgZGF0ZXRpbWU6OnRleHQgZm9yIHNvbWUgZGF0ZXRpbWUgdHlwZXMgYXJlIG11 dGFibGUuDQo+PiAgICAgZGF0ZXRpbWU6OnRleHQgY2FuIGJlIG1hZGUgaW1tdXRhYmxlIGJ5 IHBhc3NpbmcgSVNPIGRhdGUNCj4+ICAgICBzdHlsZSBpbnRvIG91dHB1dCBmdW5jdGlvbnMg KGxpa2UgaW4ganNvbnBhdGgpLg0KPj4NCj4+ICAgLSBEaXNhYmxlZCBub24tQ29uc3QgZXhw cmVzc2lvbnMgaW4gREVGQVVMVCBPTiBFTVBUWSBpbiBub24NCj4+ICAgICBFUlJPUiBPTiBF UlJPUiBjYXNlLiAgTm9uLWNvbnN0YW50IGV4cHJlc3Npb25zIGFyZSB0cmllZCB0bw0KPj4g ICAgIGV2YWx1YXRlIGludG8gQ29uc3QgZGlyZWN0bHkgaW5zaWRlIHRyYW5zZm9ybUV4cHIo KS4NCj4+ICAgICBNYXliZSBpdCB3b3VsZCBiZSBiZXR0ZXIgdG8gc2ltcGx5IHJlbW92ZSBE RUZBVUxUIE9OIEVNUFRZLg0KPiANCj4gDQo+IFllcywgSSB0aGluayB0aGF0J3Mgd2hhdCBJ IHN1Z2dlc3RlZCB1cHRocmVhZC4gSSBkb24ndCB0aGluayBERUZBVUxUIE9ODQo+IEVNUFRZ IG1hdHRlcnMgdGhhdCBtdWNoLCBhbmQgd2UgY2FuIHJldmlzaXQgaXQgZm9yIHJlbGVhc2Ug MTYuIElmIGl0J3MNCj4gc2ltcGxlciBwbGVhc2UgZG8gaXQgdGhhdCB3YXkuDQo+IA0KPiAN Cj4+IEl0IGlzIHBvc3NpYmxlIHRvIGVhc2lseSBzcGxpdCB0aGlzIHBhdGNoIGludG8gc2V2 ZXJhbCBzdWJwYXRjaGVzLA0KPj4gSSB3aWxsIGRvIGl0IGlmIG5lZWRlZC4NCj4gDQo+IA0K PiBUaGFua3MsIHByb2JhYmx5IGEgZ29vZCBpZGVhIGJ1dCBJIHdpbGwgc3RhcnQgcmV2aWV3 aW5nIHdoYXQgeW91IGhhdmUNCj4gbm93LiBBbmRyZXMgYW5kIG90aGVycyBwbGVhc2UgY2hp bWUgaW4gaWYgeW91IGNhbi4NCg0KVGhhbmtzIE5pa2l0YSENCg0KSSBsb29rZWQgdGhyb3Vn aCB0aGUgdGVzdHMgdG8gc2VlIGlmIHdlIHdvdWxkIG5lZWQgYW55IGRvYyBjaGFuZ2VzLCBl LmcuIA0KaW4gWzFdLiBJIG5vdGljZWQgdGhhdCB0aGlzIGhpbnQ6DQoNCiJISU5UOiAgVXNl IEVSUk9SIE9OIEVSUk9SIGNsYXVzZSBvciB0cnkgdG8gc2ltcGxpZnkgZXhwcmVzc2lvbiBp bnRvIA0KY29uc3RhbnQtbGlrZSBmb3JtIg0KDQpsYWNrcyBhIHBlcmlvZCBvbiB0aGUgZW5k LCB3aGljaCBpcyBjb252ZW50aW9uLg0KDQpJIGRvbid0IGtub3cgaWYgdGhlIFNRTC9KU09O IHN0YW5kYXJkIGNhbGxzIG91dCBpZiBkb21haW5zIHNob3VsZCBiZSANCmNhc3RhYmxlLCBi dXQgaWYgaXQgZG9lcywgd2Ugc2hvdWxkIGRvY3VtZW50IGluIFsxXSB0aGF0IHdlIGFyZSBu b3QgDQpjdXJyZW50bHkgc3VwcG9ydGluZyB0aGVtIGFzIHJldHVybiB0eXBlcywgc28gdGhh dCB3ZSdyZSBvbmx5IHN1cHBvcnRpbmcgDQoiY29uc3RhbnQtbGlrZSIgZXhwcmVzc2lvbnMg d2l0aCBleGFtcGxlcy4NCg0KTG9va2luZyBmb3J3YXJkIHRvIGhlYXJpbmcgb3RoZXIgZmVl ZGJhY2suDQoNClRoYW5rcywNCg0KSm9uYXRoYW4NCg0KWzFdIGh0dHBzOi8vd3d3LnBvc3Rn cmVzcWwub3JnL2RvY3MvMTUvZnVuY3Rpb25zLWpzb24uaHRtbCNGVU5DVElPTlMtU1FMSlNP Tg0K --------------gFTaEEL7B6VtSgE2Y2BfYVVZ-- --------------500vUlDhpNyv6Lm5AIEkchOX 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/x8QSccp8cZScFAmMKRrMFAwAAAAAACgkQ8QSccp8cZSdV ohAAowwAIa1JuvB2upEYJmT494wdBm61UIJkgEJZK9WyQXTR7L3FIuzJy2oJpA4oPqY7vQwrYF33 7eBBCkaAEpFSxdntAKSJQrA3SJ8UWG6Nyh90V9yMn4NgEAxzRgVnoFRHFJslsAvszYdtdUCb5kJr VMQwCVLRVR3tj31LozdgPAGFeiXvIcKdnGtyEv3DyWhC5pgvYNHmTjKAswkKHrUX6DlcygivXp+n U+f0lf2mSTaTerOBiSTBxxa4IP+JcmMsuZOjq1mS7eyyX6qqv3EaH3Zz5FsjS5NjCKJ1WjMzw/6R 7p2acDMhBtJo9b2d/WvVVHa1pFv+U4Vk8/IBXGl2RDJN5ic+oR8/qZVzHNdEWXLGgcM6cjV4xhY/ TCYwMB9rtknsoeC3A9reqX+haMbCjxdiWNfqpZGJHF0TNJwp5OD5jhw0B7d0WlkxfyyNapPGsaaL V7vuJ56ssGiTwBAWrDSeuEaI/ZKN1CHL/BloXKtdRuva2Z9me7MIsvBop+VXLxwESG8dYqxICqGi gap/JSInb5KMIAqer+YiBl6tBm6wB9ksz48M3Dy7IynB8UwZ+43LCmaFskeIebPEw0UyHM5biEub CRyI0fDN1Ri8NzWeRtfs7mHFeoYofZViEnMhJd4sr9CoZ5p7Ick2ISpbi2Q/wd+p0vnYrYrp3Pdj v0w= =Y6Oq -----END PGP SIGNATURE----- --------------500vUlDhpNyv6Lm5AIEkchOX--