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 1oP2iY-0007Xl-82 for pgsql-hackers@arkaria.postgresql.org; Fri, 19 Aug 2022 14:11:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oP2iW-0007no-4l for pgsql-hackers@arkaria.postgresql.org; Fri, 19 Aug 2022 14:11:20 +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 1oP2iV-0007nf-QK for pgsql-hackers@lists.postgresql.org; Fri, 19 Aug 2022 14:11:19 +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 1oP2iP-0005Hv-8J for pgsql-hackers@lists.postgresql.org; Fri, 19 Aug 2022 14:11:19 +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:From:References:Cc: To:Subject:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=qcQCmMa9nXaYSyz7bQcOisOeqGF4Iv9MG7QLOMHbA1o=; b=KJgZfDhKlRzKIp1JRTEmQkGYZ6 vgx7MCbcsW1oIoKl6EF7feJrfXy4XcjI+pMQjZ0WS01bXqNnfql7m68OOgj531qoA76y7B/EUFk5m AXMv5ZKtBjMDjblmxqTh4yvbzSXWXSgL+OjQQytMJnP0IjJKjtUt3j/uU6yCp7dfStXRifWs7xuun V4P8r9JXAdDzDL4C/460i1NWYs4Mbfqy/Ltbd6MV3VOkN7f2hynfJZ9N1+w1rHDvX0sIO354eTBdc 2kKKpHD5TnVbbdVvvxlt6M6XU2M+QvNG1wLE+KodgjHbKK1y5ogDByBIbSweSqXafXytHTXTXBy0P OxtCZ1gQ==; 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 1oP2iI-0000tr-PG; Fri, 19 Aug 2022 14:11:09 +0000 Message-ID: <69022273-e7e3-6d1a-10f8-d1b4740e4b97@postgresql.org> Date: Fri, 19 Aug 2022 10:11:01 -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 Subject: Re: SQL/JSON features for v15 Content-Language: en-US To: Nikita Glukhov , Andres Freund Cc: PostgreSQL Hackers , Andrew Dunstan , Tom Lane , Michael Paquier , John Naylor , Amit Langote , Robert Haas 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> From: "Jonathan S. Katz" In-Reply-To: <7d83684b-7932-9f29-400b-0beedfafcdd4@postgrespro.ru> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------sWilv2n0dwxJ58Qs007Y9JqI" 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) --------------sWilv2n0dwxJ58Qs007Y9JqI Content-Type: multipart/mixed; boundary="------------Af3FsvXd0jKQA1EMvqaPEibL"; protected-headers="v1" From: "Jonathan S. Katz" To: Nikita Glukhov , Andres Freund Cc: PostgreSQL Hackers , Andrew Dunstan , Tom Lane , Michael Paquier , John Naylor , Amit Langote , Robert Haas Message-ID: <69022273-e7e3-6d1a-10f8-d1b4740e4b97@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> In-Reply-To: <7d83684b-7932-9f29-400b-0beedfafcdd4@postgrespro.ru> --------------Af3FsvXd0jKQA1EMvqaPEibL Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 SGksDQoNCk9uIDgvMTcvMjIgMTE6NDUgUE0sIE5pa2l0YSBHbHVraG92IHdyb3RlOg0KPiBI aSwNCj4gDQo+IE9uIDE3LjA4LjIwMjIgMDQ6NDUsIEpvbmF0aGFuIFMuIEthdHogd3JvdGU6 DQo+Pg0KPj4gT24gOC8xNS8yMiAxMDoxNCBQTSwgQW5kcmVzIEZyZXVuZCB3cm90ZToNCj4+ DQo+Pj4gSSBwdXNoZWQgYSBmZXcgY2xlYW51cHMgdG8gDQo+Pj4gaHR0cHM6Ly9naXRodWIu Y29tL2FuYXJhemVsL3Bvc3RncmVzL2NvbW1pdHMvanNvbg0KPj4+IHdoaWxlIEkgd2FzIGhh Y2tpbmcgb24gdGhpcyAoaWdub3JlIHRoYXQgaXQncyBiYXNlZCBvbiB0aGUgbWVzb24gDQo+ Pj4gdHJlZSwgdGhhdCdzDQo+Pj4ganVzdCBmYXN0ZXIgZm9yIG1lKS4gU29tZSBvZiB0aGVt IG1pZ2h0IG5vdCBiZSBhcHBsaWNhYmxlIGFueW1vcmUsIA0KPj4+IGJ1dCBpdA0KPj4+IG1p Z2h0IHN0aWxsIG1ha2Ugc2Vuc2UgZm9yIHlvdSB0byBsb29rIGF0Lg0KPj4NCj4+IFdpdGgg Uk1UIGhhdCBvbiwgdGhpcyBhcHBlYXJzIHRvIGJlIG1ha2luZyBwcm9ncmVzcy4gQSBmZXcg cXVlc3Rpb25zIC8gDQo+PiBjb21tZW50cyBmb3IgdGhlIGdyb3VwOg0KPj4NCj4+IDEuIE5p a2l0YTogRGlkIHlvdSBoYXZlIGEgY2hhbmNlIHRvIHJldmlldyBBbmRyZXMncyBjaGFuZ2Vz IGFzIHdlbGw/DQo+IA0KPiBZZXMsIEkgaGF2ZSByZXZpZXdlZCBBbmRyZXMncyBjaGFuZ2Vz LCB0aGV5IGFsbCBhcmUgb2suDQoNClRoYW5rIHlvdSENCg0KPiBUaGVuIEkgc3RhcnRlZCB0 byBkbyBvbiB0aGUgdG9wIG9mIGl0IG90aGVyIGZpeGVzIHRoYXQgaGVscCB0byBhdm9pZA0K PiBzdWJ0cmFuc2FjdGlvbnMgd2hlbiB0aGV5IGFyZSBub3QgbmVlZGVkLiBBbmQgaXQgZW5k ZWQgaW4gdGhlIG5ldw0KPiByZWZhY3RvcmluZyBvZiBjb2VyY2lvbiBjb2RlLiAgQWxzbyBJ IG1vdmVkIGhlcmUgZnJvbSB2Ni0wMDAzIGZpeCBvZg0KPiBFeGVjRXZhbEpzb25OZWVkU3Vi dHJhbnNhY3Rpb24oKSB3aGljaCBjb25zaWRlcnMgbW9yZSBjYXNlcy4NCg0KR3JlYXQuDQoN CkFuZHJlcywgUm9iZXJ0OiBEbyB0aGVzZSBjaGFuZ2VzIGFkZHJlc3MgeW91ciBjb25jZXJu cyBhYm91dCB0aGUgdXNlIG9mIA0Kc3Vic3RyYW5zYWN0aW9ucyBhbmQgcmVkdWNlIHRoZSBy aXNrIG9mIHhpZCB3cmFwYXJvdW5kPw0KDQo+IE9uIDE2LjA4LjIwMjIgMDU6MTQsIEFuZHJl cyBGcmV1bmQgd3JvdGU6DQo+Pj4gQnV0IGZvciBKSVQgSSBzdGlsbCBoYWQgdG8gY29uc3Ry dWN0IGFkZGl0aW9uYWwgRXhwclN0YXRlIHdpdGggYQ0KPj4+IGZ1bmN0aW9uIGNvbXBpbGVk IGZyb20gc3ViZXhwcmVzc2lvbiBzdGVwcy4NCj4gDQo+PiBXaHkgZGlkIHlvdSBoYXZlIHRv IGRvIHRoaXM/DQo+IA0KPiBJIHNpbXBseSBkaWQgbm90IGRhcmUgdG8gaW1wbGVtZW50IGNv bXBpbGF0aW9uIG9mIHJlY3Vyc2l2ZWx5LWNhbGxhYmxlDQo+IGZ1bmN0aW9uIHdpdGggYWRk aXRpb25hbCBwYXJhbWV0ZXIgc3RlcG5vLiAgSW4gdGhlIHY4IHBhdGNoIEkgZGlkIGl0DQo+ IGJ5IGFkZGluZyBhIHN3aXRjaCB3aXRoIGFsbCBwb3NzaWJsZSBqdW1wIGFkZHJlc3NlcyBv ZiBFRU9QX1NVQlRSQU5TDQo+IHN0ZXBzIGluIHRoZSBiZWdpbm5pbmcgb2YgdGhlIGZ1bmN0 aW9uLiAgQW5kIGl0IHJlYWxseSBzZWVtcyB0byB3b3JrDQo+IGZhc3RlciwgYnV0IG5lZWRz IG1vcmUgZXhwbG9yYXRpb24uICBTZWUgcGF0Y2ggMDAwMywgd2hlcmUgYm90aA0KPiB2YXJp YW50cyBwcmVzZXJ2ZWQgdXNpbmcgI2lmZGVmLg0KPiANCj4gDQo+IFRoZSBkZXNjaXByaW9u IG9mIHRoZSB2NyBwYXRjaGVzOg0KPiANCj4gMDAwMSBTaW1wbGlmeSBKc29uRXhwciBleGVj dXRpb24NCj4gICBBbmRyZXMncyBjaGFuZ2VzICsgbWluZToNCj4gICAgLSBBZGRlZCBKc29u Q29lcmNpb25UeXBlIGVudW0sIGZpZWxkcyBsaWtlIHZpYV9pbyByZXBsYWNlZCB3aXRoIGl0 DQo+ICAgIC0gRW1pdCBvbmx5IGNvbnRleHQgaXRlbSBzdGVwcyBpbiBKU09OX1RBQkxFX09Q IGNhc2UNCj4gICAgLSBTa2lwIGNvZXJjaW9uIG9mIE5VTExzIHRvIG5vbi1kb21haW4gdHlw ZXMgKGlzIGl0IGNvcnJlY3Q/KQ0KPiANCj4gMDAwMiBGaXggcmV0dXJuaW5nIG9mIGpzb25b Yl0gZG9tYWlucyBpbiBKU09OX1ZBTFVFOg0KPiAgICBzaW1wbHkgcmViYXNlIG9mIHY2IG9u dG8gMDAwMQ0KPiANCj4gMDAwMyBBZGQgRUVPUF9TVUJUUkFOUyBleGVjdXRvciBzdGVwDQo+ ICAgIHY2ICsgbmV3IHJlY3Vyc2l2ZSBKSVQNCj4gDQo+IDAwMDQgU3BsaXQgSnNvbkV4cHIg ZXhlY3V0aW9uIGludG8gc3RlcHMNCj4gICAgc2ltcGx5IHJlYmFzZSBvZiB2NiArIHVzZWQg TExNQnVpbGRTd2l0Y2goKSBpbiBFRU9QX0pTT05FWFBSDQoNCldoYXQgZG8gZm9sa3MgdGhp bmsgb2YgdGhlc2UgcGF0Y2hlcz8NCg0KVGhhbmtzLA0KDQpKb25hdGhhbg0K --------------Af3FsvXd0jKQA1EMvqaPEibL-- --------------sWilv2n0dwxJ58Qs007Y9JqI 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/x8QSccp8cZScFAmL/mfUFAwAAAAAACgkQ8QSccp8cZSeE nRAAgThsgQwKYK0H7i699MbJgYsZcu4LIIxq+re1kxoxOHvv3KplMySgxMy/gmo3MQbKOAcK25Je /9N6LbnCa3M2ZsA55CotEkl9FJc8VhPeQUm2b1qCUw4Sc5jQM7VYGVNm7GZU+V/lgenNcsslTM1g IT404zjcRvYq6gxhczHDlUavZXaLXZIKIkR7inabh3Q88iUSlqmyh080guGTQiuF4jqgB0WqT8ny jIWu1nJBxy6U22gtvRSYzVlI0yQgS5vOtteRYFCA0qEJDxpOChh/+tnT+IHUY5XF5Ey0uyn8kV+I RlBV/VJVS8GPG7OMFkTv6eZ2MWA9l29MlnJ/MYAaurBdV3ptEJ76DF6a1aEZ+v+QgdR4wYfcVIGu fwNPKYyNur5QOMU3JI89ma7ijfTkFL3F7dc7Z7ZwqeZH58dF+fZ8l7Odhx6ohyOvDorYRbEEAzq9 KqAVDzRKQXqWcgmq4NG7500w65tdicHwBSIATn5ek1lYXsdziAYyxL4T29NlvHkK9Uw+QNVuYX5o NzzUZM+SPcldosE4G4oZv2hjJBPbxlhGIUohHGZAK2UH/6UsO7uSQvJ/AGZ2tG5bL2dtVZf4vp7X fkbzEn7H8bq4wGeZxpUaV8TRvlEy9OyRYhnd33fhE1uM4oRxvqu5Hc4fZOz2d9SmcmDjQzRkI8xT tdI= =Beb/ -----END PGP SIGNATURE----- --------------sWilv2n0dwxJ58Qs007Y9JqI--