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 1oTQto-0003W0-M3 for pgsql-hackers@arkaria.postgresql.org; Wed, 31 Aug 2022 16:49:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oTQtn-0007Jq-GP for pgsql-hackers@arkaria.postgresql.org; Wed, 31 Aug 2022 16:49:07 +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 1oTQtm-0007Jg-WB for pgsql-hackers@lists.postgresql.org; Wed, 31 Aug 2022 16:49:07 +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 1oTQtk-00070a-4h for pgsql-hackers@lists.postgresql.org; Wed, 31 Aug 2022 16:49:05 +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=FeXBkek4fhRl3oaw6eAKTHOjzUfT+GZQOlJF8wyTGuA=; b=p2hfLuRdGFxjv4uEYACS2geiT8 qX+GxtL0agyEKNuBFUJRBrxJRS6k4g96r2vJhyYc4Y1mm0/aGUJYFOYIbCvtPsMlnmsLNqkNStkUL cPjSSReIe1pFt+d19POXQohwBj/9vAddCING1efcq18QzzpzUNElv3yt6rUdQUr0I6T1uNFAg8Zg5 fdbo5QSVkEjCqEm6HJ8Sh/eu97/gUsBfBomaaCabihtSlciRgThFZ8gols2Kpy5WiyXHTcjKLu+9m cbZSoJnYDNIjsmo35SVkplDMMjzfyKtLq+jFwFXddk3sHQhzk9ezWsXYXTDggZXNJmOxPBGmEhn4e ajltFi6Q==; 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 1oTQtc-0007fM-BZ; Wed, 31 Aug 2022 16:48:58 +0000 Message-ID: <40d2c882-bcac-19a9-754d-4299e1d87ac7@postgresql.org> Date: Wed, 31 Aug 2022 12:48:52 -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: Robert Haas Cc: Andrew Dunstan , Amit Langote , Nikita Glukhov , Alvaro Herrera , Tom Lane , Andres Freund , PostgreSQL Hackers , Michael Paquier , John Naylor References: <20220830092008.6dbublx6la226zis@alvherre.pgsql> <2276d20d-43ff-f9f6-5c9c-c2875739e66c@postgresql.org> From: "Jonathan S. Katz" Subject: Re: SQL/JSON features for v15 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------AsM6PJFkVt4VC0XRz9CoOCJ9" 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) --------------AsM6PJFkVt4VC0XRz9CoOCJ9 Content-Type: multipart/mixed; boundary="------------2toMCsU0nyM3lvwxtN4B7yZp"; protected-headers="v1" From: "Jonathan S. Katz" To: Robert Haas Cc: Andrew Dunstan , Amit Langote , Nikita Glukhov , Alvaro Herrera , Tom Lane , Andres Freund , PostgreSQL Hackers , Michael Paquier , John Naylor Message-ID: <40d2c882-bcac-19a9-754d-4299e1d87ac7@postgresql.org> Subject: Re: SQL/JSON features for v15 References: <20220830092008.6dbublx6la226zis@alvherre.pgsql> <2276d20d-43ff-f9f6-5c9c-c2875739e66c@postgresql.org> In-Reply-To: --------------2toMCsU0nyM3lvwxtN4B7yZp Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOC8zMS8yMiAxMjoyNiBQTSwgUm9iZXJ0IEhhYXMgd3JvdGU6DQo+IE9uIFdlZCwgQXVn IDMxLCAyMDIyIGF0IDEwOjIwIEFNIEpvbmF0aGFuIFMuIEthdHogPGprYXR6QHBvc3RncmVz cWwub3JnPiB3cm90ZToNCj4+IEFuZHJlcywgUm9iZXJ0LCBUb206IFdpdGggdGhpcyByZWNl bnQgd29yaywgaGF2ZSBhbnkgb2YgeW91ciBvcGluaW9ucw0KPj4gY2hhbmdlZCBvbiBpbmNs dWRpbmcgU1FML0pTT04gaW4gdjE1Pw0KPiANCj4gTm8uIE5vdGhpbmcncyBiZWVuIGNvbW1p dHRlZCwgYW5kIHRoZXJlJ3Mgbm8gdGltZSB0byByZXZpZXcgYW55dGhpbmcNCj4gaW4gZGV0 YWlsLCBhbmQgdGhlcmUgd2FzIG5ldmVyIGdvaW5nIHRvIGJlLg0KDQpPSy4gQmFzZWQgb24g dGhpcyBmZWVkYmFjaywgdGhlIFJNVCBpcyBnb2luZyB0byByZXF1ZXN0IHRoYXQgdGhpcyBp cyANCnJldmVydGVkLg0KDQpXaXRoIFJNVCBoYXQgb24gLS0gQW5kcmV3IGNhbiB5b3UgcGxl YXNlIHJldmVydCB0aGUgcGF0Y2hzZXQ/DQoNCj4gIE5pa2l0YSBzYWlkIGhlIHdhcyByZWFk eQ0KPiB0byBzdGFydCBoYWNraW5nIGluIG1pZC1BdWd1c3QuIFRoYXQncyBnb29kIG9mIGhp bSwgYnV0IGZlYXR1cmUgZnJlZXplDQo+IHdhcyBpbiBBcHJpbC4gV2UgZG9uJ3Qgc3RhcnQg aGFja2luZyBvbiBhIGZlYXR1cmUgNCBtb250aHMgYWZ0ZXIgdGhlDQo+IGZyZWV6ZS4gSSdt IHVud2lsbGluZyB0byBkcm9wIGV2ZXJ5dGhpbmcgSSdtIHdvcmtpbmcgb24gdG8gcmV2aWV3 DQo+IHBhdGNoZXMgdGhhdCB3ZXJlIHdyaXR0ZW4gaW4gYSBsYXN0IG1pbnV0ZSBydXNoLiBF dmVuIGlmIHRoZXNlIHBhdGNoZXMNCj4gd2VyZSBtb3JlIGltcG9ydGFudCB0byBtZSB0aGFu IG15IG93biB3b3JrLCB3aGljaCB0aGV5IGFyZSBub3QsIEkNCj4gY291bGRuJ3QgcG9zc2li bHkgZG8gYSBnb29kIGpvYiByZXZpZXdpbmcgY29tcGxleCBwYXRjaGVzIG9uIHRvcCBvZg0K PiBvdGhlciBjb21wbGV4IHBhdGNoZXMgaW4gYW4gYXJlYSB0aGF0IEkgaGF2ZW4ndCBzdHVk aWVkIGluIHllYXJzLiBBbmQNCj4gaWYgSSBjb3VsZCBkbyBhIGdvb2Qgam9iLCBubyBkb3Vi dCBJJ2QgZmluZCBhIGJ1bmNoIG9mIHByb2JsZW1zIC0NCj4gd2hldGhlciB0aGV5IHdvdWxk IGJlIGxhcmdlIG9yIHNtYWxsLCBJIGRvbid0IGtub3cgLSBhbmQgdGhlbiB0aGF0DQo+IHdv dWxkIGxlYWQgdG8gbW9yZSBjaGFuZ2VzIGV2ZW4gY2xvc2VyIHRvIHRoZSBpbnRlbmRlZCBy ZWxlYXNlIGRhdGUuDQo+IA0KPiBJIGp1c3QgZG9uJ3QgdW5kZXJzdGFuZCB3aGF0IHRoZSBS TVQgdGhpbmtzIGl0IGlzIGRvaW5nIGhlcmUuIFdoZW4gYQ0KPiBjb25jZXJuIGlzIHJhaXNl ZCBhYm91dCB3aGV0aGVyIGEgZmVhdHVyZSBpcyBhbnl3aGVyZSBjbG9zZSB0byBiZWluZw0K PiBpbiBhIHJlbGVhc2FibGUgc3RhdGUgaW4gQXVndXN0LCAiaGFjayBvbiBpdCBzb21lIG1v cmUgYW5kIHRoZW4gc2VlDQo+IHdoZXJlIHdlJ3JlIGF0IiBzZWVtcyBsaWtlIGFuIG9idmlv dXNseSBpbXByYWN0aWNhbCB3YXkgZm9yd2FyZC4gSXQNCj4gc2VlbWVkIGNsZWFyIHRvIG1l IGZyb20gdGhlIG1vbWVudCB0aGF0IEFuZHJlcyByYWlzZWQgaGlzIGNvbmNlcm5zDQo+IHRo YXQgdGhlIG9ubHkgdHdvIHZpYWJsZSBzdHJhdGVnaWVzIHdlcmUgKDEpIHJldmVydCB0aGUg ZmVhdHVyZSBhbmQgYmUNCj4gc2FkIG9yICgyKSBkZWNpZGUgdG8gc2hpcCBpdCBhbnl3YXkg YW5kIGhvcGUgdGhhdCBBbmRyZXMgaXMgaW5jb3JyZWN0DQo+IGluIHRoaW5raW5nIHRoYXQg aXQgd2lsbCBiZWNvbWUgYW4gZW1iYXJyYXNzbWVudCB0byB0aGUgcHJvamVjdC4gVGhlDQo+ IFJNVCBoYXMgY2hvc2VuIG5laXRoZXIgb2YgdGhlc2UsIGFuZCBpbiBmYWN0LCByZWFsbHkg c2VlbXMgdG8gd2FudA0KPiBzb21lb25lIGVsc2UgdG8gbWFrZSB0aGUgZGVjaXNpb24uIEJ1 dCB0aGF0J3Mgbm90IGhvdyBpdCB3b3Jrcy4gVGhlDQo+IFJNVCBjb25jZXB0IHdhcyBpbnZl bnRlZCBwcmVjaXNlbHkgdG8gc29sdmUgcHJvYmxlbXMgbGlrZSB0aGlzIG9uZSwNCj4gd2hl cmUgdGhlIHBhdGNoIGF1dGhvcnMgZG9uJ3QgcmVhbGx5IHdhbnQgdG8gcmV2ZXJ0IGl0IGJ1 dCBvdGhlcg0KPiBwZW9wbGUgdGhpbmsgaXQncyBwcmV0dHkgYnVzdGVkLiBJZiBzdWNoIHBy b2JsZW1zIHdlcmUgYmVzdCBhZGRyZXNzZWQNCj4gYnkgd2FpdGluZyBmb3IgYSBsb25nIHRp bWUgdG8gc2VlIHdoZXRoZXIgYW55dGhpbmcgY2hhbmdlcywgd2UNCj4gd291bGRuJ3QgbmVl ZCBhbiBSTVQuIFRoYXQncyBleGFjdGx5IGhvdyB3ZSB1c2VkIHRvIGhhbmRsZSB0aGVzZSBr aW5kcw0KPiBvZiBwcm9ibGVtcywgYW5kIGl0IHN1Y2tlZC4NCg0KVGhpcyBpcyBmYWlyIGZl ZWRiYWNrLiBIb3dldmVyLCB0aGVyZSBhcmUgYSBmZXcgdGhpbmdzIHRvIGNvbnNpZGVyIGhl cmU6DQoNCjEuIFdoZW4gQW5kcmVzIHJhaXNlZCBoaXMgaW5pdGlhbCBjb25jZXJucywgdGhl IFJNVCBkaWQgcmVjb21tZW5kIHRvIA0KcmV2ZXJ0IGJ1dCBkaWQgbm90IGZvcmNlIGl0LiBQ YXJ0IG9mIHRoZSBSTVQgY2hhcnRlciBpcyB0byB0cnkgdG8gZ2V0IA0KY29uc2Vuc3VzIGJl Zm9yZSBkb2luZyBzbyBhbmQgYWZ0ZXIgd2UndmUgZXhoYXVzdGVkIHRoZSBjb21tdW5pdHkg DQpwcm9jZXNzLiBBcyB3ZSBtb3ZlZCBjbG9zZXIsIHRoZSBwYXRjaCBvdGhlcnMgcHJvcG9z ZWQgc29tZSBzdWdnZXN0aW9ucyANCndoaWNoIG90aGVyIGZvbGtzIHdlcmUgYW1lbmFibGUg dG8gdHJ5aW5nLg0KDQpVbmZvcnR1bmF0ZWx5LCB0aW1lIGhhcyBydW4gb3V0LiBIb3dldmVy LA0KDQoyLiBPbmUgb2YgdGhlIG90aGVyIG1haW4gZ29hbHMgb2YgdGhlIFJNVCBpcyB0byBl bnN1cmUgdGhlIHJlbGVhc2Ugc2hpcHMgDQoib24gdGltZSIgd2hpY2ggd2UgZGVmaW5lIHRv IGJlIGxhdGUgUTMvZWFybHkgUTQuIFdlIGZhY3RvcmVkIHRoYXQgaW50byANCnRoZSBkZWNp c2lvbiBtYWtpbmcgcHJvY2VzcyBhcm91bmQgdGhpcy4gV2UgYXJlIHN0aWxsIG9uIHRpbWUg Zm9yIHRoZSANCnJlbGVhc2UuDQoNCkkgdGFrZSByZXNwb25zaWJpbGl0eSBmb3IgdGhlIGRl Y2lzaW9uIG1ha2luZy4gSSB3b3VsZCBiZSBvcGVuIHRvIA0KZGlzY3VzcyB0aGlzIGZ1cnRo ZXIgYXJvdW5kIHdoYXQgd29ya2VkIC8gd2hhdCBkaWRuJ3Qgd2l0aCB0aGUgUk1UIGFuZCAN CndoZXJlIHdlIGNhbiBpbXByb3ZlIGluIHRoZSBmdXR1cmUuDQoNClRoYW5rcywNCg0KSm9u YXRoYW4NCg== --------------2toMCsU0nyM3lvwxtN4B7yZp-- --------------AsM6PJFkVt4VC0XRz9CoOCJ9 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/x8QSccp8cZScFAmMPkPQFAwAAAAAACgkQ8QSccp8cZSf6 RQ/9FBtR2BoESkKRMmc/YA6oyOE22IonHjJKTL4+YQKrazmlrkcJ/1NEIeGi/xyV+8CNp4he0OR0 UAyEr7A+zJY8TF4NWXMAa6Eq2ZptjG2sEHVCRu6JcPZDQL9hBNwD1weqeY41NWUeG97pokhhj9hM QS49wbLmQH0/26NGB4i7/4v6KzhoFj8YfdQu5XDzQTjGw3jY33GeATGGCIbN/QLS9LtEXc4goaW9 Tk/xrnTaZJSalFc0TQqyTUN29V28AQxIHcvPNeH6Qpxe794TYZO7IEpmJ4MLII7VVUz0Cgvu6Kmn RKiBAjCDsjZDjTE34TyMloLmaOAa+jNUKbLVvFt6ureTBEbSEvvSvE0VySrq20qgd8dwBCA2D4px XY0NEB5Vfv7Gf/TLQqe22uIGSaXwyN4EUWRylnFWfrP0EIio+qaq7bLkzpt0KqpXb8U02ZTlhJ60 MZXZBYs5ymlw0gUH/yytZyoAn6iOaN7yzUG6gQ2GrjTIE69WYRIbeyXMbuiwA99JPPMQY6KGfPH6 Op1ySgT5uWyCtp9HdUlbIv/HPsYU85iG4z+TXIypK8jXjbUiaje5xU3PJW6/XLaF7pATyqAunyvb VxnDd51b9M+ar7ygsTomsO78DX4+zy3OEqYQxwiH6Lanbh0Zyy53i5pTIqgJ2pe2UgDtdgE7foec m7c= =GMTD -----END PGP SIGNATURE----- --------------AsM6PJFkVt4VC0XRz9CoOCJ9--