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 1oQJ5Y-0007cZ-Ew for pgsql-hackers@arkaria.postgresql.org; Tue, 23 Aug 2022 01:52:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oQJ5X-0006NO-CI for pgsql-hackers@arkaria.postgresql.org; Tue, 23 Aug 2022 01:52:19 +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 1oQJ5W-0006NF-GA for pgsql-hackers@lists.postgresql.org; Tue, 23 Aug 2022 01:52:19 +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 1oQJ5R-0000J2-35 for pgsql-hackers@lists.postgresql.org; Tue, 23 Aug 2022 01:52:17 +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:References:Cc:To: From:Subject:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=0i5paoHG/+GJmARTnwDF8opilnwTtcnhdPwzMzAGW4U=; b=AG68xR0G1SReZ6R1KCiKX7RWb/ 89xXHaBfvGIp0SmcCzTkpiB9SsHzRQ8HMJHwqfI/4PdkAjlqKvalaLbyejMMcPQuAgONBAFN200Vz mNOmRzfsMy1JqGbf4XJgWduSKkPieCP/XTFZeCdNSrR/WmDY69xxLmahYGVXdD8Lz6AExgp0MZD+x UN/vRAte1BCjD/K7gnGip550ZRexhiN2bNEDLuGlr9rERgV2vlfy3MRwFMIZGOzmjcrpT4iXIjedy pqMvqBb0Hs1Z5uc3bMooAA/4U2jvhcPY0DAFVHeG6w/c+ktFevLq8UG/Atz+PM+Lk2sXNTvjxnRMB s3ZsoA3Q==; 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 1oQJ5L-0008QP-NR; Tue, 23 Aug 2022 01:52:09 +0000 Message-ID: <92cab50c-152b-84fc-fd49-12b936113a3d@postgresql.org> Date: Mon, 22 Aug 2022 21:52: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 From: "Jonathan S. Katz" 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> <69022273-e7e3-6d1a-10f8-d1b4740e4b97@postgresql.org> In-Reply-To: <69022273-e7e3-6d1a-10f8-d1b4740e4b97@postgresql.org> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------XrOh0ItQoxt4k0Hk7dUgGHu5" 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) --------------XrOh0ItQoxt4k0Hk7dUgGHu5 Content-Type: multipart/mixed; boundary="------------oROFrn0wn6a4dq6WAaZT5ANq"; 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: <92cab50c-152b-84fc-fd49-12b936113a3d@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> In-Reply-To: <69022273-e7e3-6d1a-10f8-d1b4740e4b97@postgresql.org> --------------oROFrn0wn6a4dq6WAaZT5ANq Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOC8xOS8yMiAxMDoxMSBBTSwgSm9uYXRoYW4gUy4gS2F0eiB3cm90ZToNCj4gSGksDQo+ IA0KPiBPbiA4LzE3LzIyIDExOjQ1IFBNLCBOaWtpdGEgR2x1a2hvdiB3cm90ZToNCj4+IEhp LA0KPj4NCj4+IE9uIDE3LjA4LjIwMjIgMDQ6NDUsIEpvbmF0aGFuIFMuIEthdHogd3JvdGU6 DQo+Pj4NCj4+PiBPbiA4LzE1LzIyIDEwOjE0IFBNLCBBbmRyZXMgRnJldW5kIHdyb3RlOg0K Pj4+DQo+Pj4+IEkgcHVzaGVkIGEgZmV3IGNsZWFudXBzIHRvIA0KPj4+PiBodHRwczovL2dp dGh1Yi5jb20vYW5hcmF6ZWwvcG9zdGdyZXMvY29tbWl0cy9qc29uDQo+Pj4+IHdoaWxlIEkg d2FzIGhhY2tpbmcgb24gdGhpcyAoaWdub3JlIHRoYXQgaXQncyBiYXNlZCBvbiB0aGUgbWVz b24gDQo+Pj4+IHRyZWUsIHRoYXQncw0KPj4+PiBqdXN0IGZhc3RlciBmb3IgbWUpLiBTb21l IG9mIHRoZW0gbWlnaHQgbm90IGJlIGFwcGxpY2FibGUgYW55bW9yZSwgDQo+Pj4+IGJ1dCBp dA0KPj4+PiBtaWdodCBzdGlsbCBtYWtlIHNlbnNlIGZvciB5b3UgdG8gbG9vayBhdC4NCj4+ Pg0KPj4+IFdpdGggUk1UIGhhdCBvbiwgdGhpcyBhcHBlYXJzIHRvIGJlIG1ha2luZyBwcm9n cmVzcy4gQSBmZXcgcXVlc3Rpb25zIA0KPj4+IC8gY29tbWVudHMgZm9yIHRoZSBncm91cDoN Cj4+Pg0KPj4+IDEuIE5pa2l0YTogRGlkIHlvdSBoYXZlIGEgY2hhbmNlIHRvIHJldmlldyBB bmRyZXMncyBjaGFuZ2VzIGFzIHdlbGw/DQo+Pg0KPj4gWWVzLCBJIGhhdmUgcmV2aWV3ZWQg QW5kcmVzJ3MgY2hhbmdlcywgdGhleSBhbGwgYXJlIG9rLg0KPiANCj4gVGhhbmsgeW91IQ0K PiANCj4+IFRoZW4gSSBzdGFydGVkIHRvIGRvIG9uIHRoZSB0b3Agb2YgaXQgb3RoZXIgZml4 ZXMgdGhhdCBoZWxwIHRvIGF2b2lkDQo+PiBzdWJ0cmFuc2FjdGlvbnMgd2hlbiB0aGV5IGFy ZSBub3QgbmVlZGVkLiBBbmQgaXQgZW5kZWQgaW4gdGhlIG5ldw0KPj4gcmVmYWN0b3Jpbmcg b2YgY29lcmNpb24gY29kZS7CoCBBbHNvIEkgbW92ZWQgaGVyZSBmcm9tIHY2LTAwMDMgZml4 IG9mDQo+PiBFeGVjRXZhbEpzb25OZWVkU3VidHJhbnNhY3Rpb24oKSB3aGljaCBjb25zaWRl cnMgbW9yZSBjYXNlcy4NCj4gDQo+IEdyZWF0Lg0KPiANCj4gQW5kcmVzLCBSb2JlcnQ6IERv IHRoZXNlIGNoYW5nZXMgYWRkcmVzcyB5b3VyIGNvbmNlcm5zIGFib3V0IHRoZSB1c2Ugb2Yg DQo+IHN1YnN0cmFuc2FjdGlvbnMgYW5kIHJlZHVjZSB0aGUgcmlzayBvZiB4aWQgd3JhcGFy b3VuZD8NCj4gDQo+PiBPbiAxNi4wOC4yMDIyIDA1OjE0LCBBbmRyZXMgRnJldW5kIHdyb3Rl Og0KPj4+PiBCdXQgZm9yIEpJVCBJIHN0aWxsIGhhZCB0byBjb25zdHJ1Y3QgYWRkaXRpb25h bCBFeHByU3RhdGUgd2l0aCBhDQo+Pj4+IGZ1bmN0aW9uIGNvbXBpbGVkIGZyb20gc3ViZXhw cmVzc2lvbiBzdGVwcy4NCj4+DQo+Pj4gV2h5IGRpZCB5b3UgaGF2ZSB0byBkbyB0aGlzPw0K Pj4NCj4+IEkgc2ltcGx5IGRpZCBub3QgZGFyZSB0byBpbXBsZW1lbnQgY29tcGlsYXRpb24g b2YgcmVjdXJzaXZlbHktY2FsbGFibGUNCj4+IGZ1bmN0aW9uIHdpdGggYWRkaXRpb25hbCBw YXJhbWV0ZXIgc3RlcG5vLsKgIEluIHRoZSB2OCBwYXRjaCBJIGRpZCBpdA0KPj4gYnkgYWRk aW5nIGEgc3dpdGNoIHdpdGggYWxsIHBvc3NpYmxlIGp1bXAgYWRkcmVzc2VzIG9mIEVFT1Bf U1VCVFJBTlMNCj4+IHN0ZXBzIGluIHRoZSBiZWdpbm5pbmcgb2YgdGhlIGZ1bmN0aW9uLsKg IEFuZCBpdCByZWFsbHkgc2VlbXMgdG8gd29yaw0KPj4gZmFzdGVyLCBidXQgbmVlZHMgbW9y ZSBleHBsb3JhdGlvbi7CoCBTZWUgcGF0Y2ggMDAwMywgd2hlcmUgYm90aA0KPj4gdmFyaWFu dHMgcHJlc2VydmVkIHVzaW5nICNpZmRlZi4NCj4+DQo+Pg0KPj4gVGhlIGRlc2NpcHJpb24g b2YgdGhlIHY3IHBhdGNoZXM6DQo+Pg0KPj4gMDAwMSBTaW1wbGlmeSBKc29uRXhwciBleGVj dXRpb24NCj4+IMKgIEFuZHJlcydzIGNoYW5nZXMgKyBtaW5lOg0KPj4gwqDCoCAtIEFkZGVk IEpzb25Db2VyY2lvblR5cGUgZW51bSwgZmllbGRzIGxpa2UgdmlhX2lvIHJlcGxhY2VkIHdp dGggaXQNCj4+IMKgwqAgLSBFbWl0IG9ubHkgY29udGV4dCBpdGVtIHN0ZXBzIGluIEpTT05f VEFCTEVfT1AgY2FzZQ0KPj4gwqDCoCAtIFNraXAgY29lcmNpb24gb2YgTlVMTHMgdG8gbm9u LWRvbWFpbiB0eXBlcyAoaXMgaXQgY29ycmVjdD8pDQo+Pg0KPj4gMDAwMiBGaXggcmV0dXJu aW5nIG9mIGpzb25bYl0gZG9tYWlucyBpbiBKU09OX1ZBTFVFOg0KPj4gwqDCoCBzaW1wbHkg cmViYXNlIG9mIHY2IG9udG8gMDAwMQ0KPj4NCj4+IDAwMDMgQWRkIEVFT1BfU1VCVFJBTlMg ZXhlY3V0b3Igc3RlcA0KPj4gwqDCoCB2NiArIG5ldyByZWN1cnNpdmUgSklUDQo+Pg0KPj4g MDAwNCBTcGxpdCBKc29uRXhwciBleGVjdXRpb24gaW50byBzdGVwcw0KPj4gwqDCoCBzaW1w bHkgcmViYXNlIG9mIHY2ICsgdXNlZCBMTE1CdWlsZFN3aXRjaCgpIGluIEVFT1BfSlNPTkVY UFINCj4gDQo+IFdoYXQgZG8gZm9sa3MgdGhpbmsgb2YgdGhlc2UgcGF0Y2hlcz8NCg0KQW5k cmVzLCBBbmRyZXcsIEFtaXQsIFJvYmVydCAtLSBhcyB5b3UgaGF2ZSBlaXRoZXIgd29ya2Vk IG9uIHRoaXMgb3IgDQpleHByZXNzZWQgb3BpbmlvbnMgLS0gYW55IHRob3VnaHRzIG9uIHRo aXMgY3VycmVudCBwYXRjaCBzZXQ/DQoNClRoYW5rcywNCg0KSm9uYXRoYW4NCg== --------------oROFrn0wn6a4dq6WAaZT5ANq-- --------------XrOh0ItQoxt4k0Hk7dUgGHu5 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/x8QSccp8cZScFAmMEMsEFAwAAAAAACgkQ8QSccp8cZSdM /Q//QjV3R0owgGaVZ3cAgZ/9mWLOhl7kam1IsHPPQPVYdXHbGJN4FGWzIHgzIV5iOuQCZkn3oC75 DeHSe9eizIaug3KuIQm4saSFVipzz2yTlALF3i2+Kw/A1UddPgKPk/C5X8fYTmCeEM/VNHwQZW34 lj+VvDgtma752F5JSvOyMBp5cu12kRMG2DNSBBKs3s5+U/35dudqwy1sgeA3hrJtfmACiG74mm2f oWo+i3WXC7nMbnl9EIQTV0lVVdc7ZK9JrfD1ne7N/NxFLob9nFgchJijHCOkSNfMIKpFtCER5GkQ ajf0mo0MmsODoepT+p11P6vAy8k5gXdPg8h8MPXYem0HqmbysYhykdyKjqjKEZvmefVKTqsXJELi BLdwqDsc9gVUbZV0K6PMM48BUtqIqkkMsrsL0JSC1lsIrMSjbxhYamh+mepPDNiYt6mIPQztHB5n x9rIyIAx8SzPnDPHwjKEcuEXaLWRWrhauFVVMKtQCwPWMbbq7AFfPuUEFbBnK1EspnAFIPraW2P6 eqIXNfcltVCEqW1gpQ/plcrpD4LCd3qEztOAzG3WV6aTWLkM6m2tNXvuVziDbtDJ7mGCrIb3PuYl x15GYU9Gn9Isp2gU0VCmLsCOovGGCj0yJIkbGiKNnQGb1IRcWwcdMEwHifA0te3c5Cn+vIDw8HIO jzI= =8Jmn -----END PGP SIGNATURE----- --------------XrOh0ItQoxt4k0Hk7dUgGHu5--