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 1oLWKe-0002BQ-Ly for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Aug 2022 21:00: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 1oLWJd-0004sa-Df for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Aug 2022 20:59:05 +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 1oLWJd-0004sR-3v for pgsql-hackers@lists.postgresql.org; Tue, 09 Aug 2022 20:59:05 +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 1oLWJa-0006oS-KG for pgsql-hackers@lists.postgresql.org; Tue, 09 Aug 2022 20:59:04 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:Subject:Cc:To:From:MIME-Version: Date:Message-ID:Sender:Reply-To:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=T1V4PKJFDAALgx0vjcTMwvGAjegpARIGBMbFcB8JTfY=; b=FM5BCUsZ3TOb8a0ocFjO8N+5aL bb4FaPYU5S7X40GrbvcYo0380bV1dnxCCDzifGyFdkappDZz5jReBjR8gQek/wix5tmCaLaZL0sg2 u3zxqeXu/ZeaWQesgc3CpLRGfRJxsqy44IBcGxYLAhhhMkXYapCYqgEpZxk1fnPWmELZeZD4Q/tDb ygSFtaQeoig+UiypxIqjnByrQx8rj5wU7FXa9GgXyxKeo5digamWPhqzcIDJ7QMiOX57LYQHq5EK8 mxQA/TZ5soxD7UYhKKb/dk/scQOcI87JNs9U5sSNCTInr/Bt9mWBfdOpRJg8mN5Ji5VRgPRuk6LfM sf92TK9g==; 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 1oLWJX-0002QD-Uw; Tue, 09 Aug 2022 20:59:02 +0000 Message-ID: Date: Tue, 9 Aug 2022 16:58:56 -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 From: "Jonathan S. Katz" To: PostgreSQL Hackers Cc: Andrew Dunstan , Andres Freund , Tom Lane , Nikita Glukhov , Michael Paquier , John Naylor Subject: SQL/JSON features for v15 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------c7axBuUX72TCiU82AMsCqGta" 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) --------------c7axBuUX72TCiU82AMsCqGta Content-Type: multipart/mixed; boundary="------------ZU6cLCD5R9bICUh4swCN8yLF"; protected-headers="v1" From: "Jonathan S. Katz" To: PostgreSQL Hackers Cc: Andrew Dunstan , Andres Freund , Tom Lane , Nikita Glukhov , Michael Paquier , John Naylor Message-ID: Subject: SQL/JSON features for v15 --------------ZU6cLCD5R9bICUh4swCN8yLF Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 SGksDQoNCihQZXJzb25hbCBoYXQsIG5vdCBSTVQgaGF0IHVubGVzcyBvdGhlcndpc2Ugbm90 ZWQpLg0KDQpUaGlzIHRocmVhZFsxXSByYWlzZWQgc29tZSBjb25jZXJucyBhcm91bmQgdGhl IGltcGxlbWVudGF0aW9uIG9mIHRoZSANClNRTC9KU09OIGZlYXR1cmVzIHRoYXQgYXJlIHNs YXRlZCBmb3IgdjE1LCB3aGljaCBpbmNsdWRlcyBhbiBvdXRzdGFuZGluZyANCm9wZW4gaXRl bVsyXS4gR2l2ZW4gdGhlIGN1cnJlbnQgc3RhdGUgb2YgdGhlIGRpc2N1c3Npb24sIHdoZW4g dGhlIFJNVCANCm1ldCBvbiBBdWcgOCwgdGhleSBzZXZlcmFsIG9wdGlvbnMsIHJlYWRhYmxl IGhlcmVbM10uIEdpdmVuIHdlIGFyZSBub3cgDQppbnRvIHRoZSBsYXRlciBwYXJ0IG9mIHRo ZSByZWxlYXNlIGN5Y2xlLCB3ZSBuZWVkIHRvIG1ha2Ugc29tZSBkZWNpc2lvbnMgDQpvbiBo b3cgdG8gcHJvY2VlZCB3aXRoIHRoaXMgZmVhdHVyZSBnaXZlbiB0aGUgY29uY2VybnMgcmFp c2VkLg0KDQpQZXIgYWRkaXRpb25hbCBkaXNjdXNzaW9uIG9uIHRoZSB0aHJlYWQsIHRoZSBn cm91cCB3YW50ZWQgdG8gcHJvdmlkZSANCm1vcmUgdmlzaWJpbGl0eSBpbnRvIHRoZSBkaXNj dXNzaW9uIHRvIGdldCBvcGluaW9ucyBvbiBob3cgdG8gcHJvY2VlZCANCmZvciB0aGUgdjE1 IHJlbGVhc2UuDQoNCldpdGhvdXQgcmVoYXNoaW5nIHRoZSB0aHJlYWQsIHRoZSBvcHRpb25z IHByZXNlbnRlZCB3ZXJlOg0KDQoxLiBGaXhpbmcgdGhlIGNvbmNlcm5zIGFkZHJlc3NlZCBp biB0aGUgdGhyZWFkIGFyb3VuZCB0aGUgdjE1IFNRTC9KU09OIA0KZmVhdHVyZXMgaW1wbGVt ZW50YXRpb24sIG5vdGluZyB0aGF0IHRoaXMgd291bGQgbGlrZWx5IGVudGFpbCBhdCBsZWFz dCANCm9uZSBtb3JlIGJldGEgcmVsZWFzZSBhbmQgd291bGQgcHVzaCB0aGUgR0EgZGF0ZSBw YXN0IG91ciBub3JtYWwgdGltZWZyYW1lLg0KDQoyLiBUcnkgdG8gY29tbWl0IGEgc3Vic2V0 IG9mIHRoZSBmZWF0dXJlcyB0aGF0IGNhdXNlZCBsZXNzIGRlYmF0ZS4gVGhpcyANCndhcyBy dWxlZCBvdXQuDQoNCjMuIFJldmVydCB0aGUgdjE1IFNRTC9KU09OIGZlYXR1cmVzIHdvcmsu DQoNCjxSTVQgaGF0Pg0KQmFzZWQgb24gdGhlIGN1cnJlbnQgcmVsZWFzZSB0aW1pbmcgYW5k IHRoZSBvcGVuIGlzc3VlcyBwcmVzZW50ZWQgb24gdGhlIA0KdGhyZWFkLCBhbmQgdGhlIFJN VCBoYWQgcmVjb21tZW5kZWQgcmV2ZXJ0aW5nLCBidXQgcHJlZmVycmVkIHRvIGRyaXZlIA0K Y29uc2Vuc3VzIG9uIG5leHQgc3RlcHMuDQo8L1JNVCBoYXQ+DQoNCiBGcm9tIGEgcmVsZWFz ZSBhZHZvY2FjeSBzdGFuZHBvaW50LCBJIG5lZWQgYWJvdXQgNiB3ZWVrcyBsZWFkIHRpbWUg dG8gDQpwdXQgdG9nZXRoZXIgdGhlIEdBIGxhdW5jaC4gV2UncmUgYXQgdGhlIHBvaW50IHdo ZXJlIEkgdHlwaWNhbGx5IGRlbGl2ZXIgDQphIGRyYWZ0IHJlbGVhc2UgYW5ub3VuY2VtZW50 LiBGcm9tIHRoaXMsIGdpdmVuIHRoaXMgaW52b2x2ZXMgYSBoaWdoIA0KdmlzaWJpbGl0eSBm ZWF0dXJlLCBJIHdvdWxkIHdhbnQgc29tZSBjbGFyaXR5IG9uIHdoYXQgb3B0aW9uIHdlIHdv dWxkIA0KbGlrZSB0byBwdXJzdWUuIE9uY2UgdGhlIGFubm91bmNlbWVudCB0cmFuc2xhdGlv biBwcm9jZXNzIGhhcyBiZWd1biAoYW5kIA0KdGhpcyBpcyB3aGVuIHdlIGhhdmUgY29uc2Vu c3VzIG9uIHRoZSByZWxlYXNlIGFubm91bmNlbWVudCksIGl0IGJlY29tZXMgDQptb3JlIGNo YWxsZW5naW5nIHRvIGNoYW5nZSB0aGluZ3Mgb3V0Lg0KDQogRnJvbSBhIHBlcnNvbmFsIHN0 YW5kcG9pbnQgKHJlc3RhdGluZyBmcm9tWzNdKSwgSSB3b3VsZCBsaWtlIHRvIHNlZSANCndo YXQgd2UgY291bGQgZG8gdG8gaW5jbHVkZSBzdXBwb3J0IGZvciB0aGlzIGJhdGNoIG9mIHRo ZSBTUUwvSlNPTiANCmZlYXR1cmVzIGluIHYxNS4gV2hhdCBpcyBpbmNsdWRlZCBsb29rcyBs aWtlIGl0IGNsb3NlcyBtb3N0IG9mIHRoZSBnYXAgDQpvbiB3aGF0IHdlJ3ZlIGJlZW4gbWlz c2luZyBzeW50YWN0aWNhbGx5IHNpbmNlIHRoZSBzdGFuZGFyZCB3YXMgYWRvcHRlZCwgDQph bmQgdGhlIEpTT05fVEFCTEUgd29yayBpcyB2ZXJ5IGNvbnZlbmllbnQgZm9yIGNvbnZlcnRp bmcgSlNPTiBkYXRhIGludG8gDQphIHJlbGF0aW9uYWwgZm9ybWF0LiBJIGJlbGlldmUgaGF2 aW5nIHRoaXMgZmVhdHVyZSBzZXQgaXMgaW1wb3J0YW50IGZvciANCm1haW50YWluaW5nIHN0 YW5kYXJkcyBjb21wbGlhbmNlLCBpbnRlcm9wZXJhYmlsaXR5LCB0b29saW5nIHN1cHBvcnQs IGFuZCANCmdlbmVyYWwgdXNhYmlsaXR5LiBQbHVzLCBKU09OIHN0aWxsIHNlZW1zIHRvIGJl IHByZXR0eSBwb3B1bGFyLg0KDQpXZSdyZSBsb29raW5nIGZvciBhZGRpdGlvbmFsIGlucHV0 IG9uIHdoYXQgbWFrZXMgc2Vuc2UgYXMgYSBiZXN0IGNvdXJzZSANCm9mIGFjdGlvbiwgZ2l2 ZW4gd2hhdCBpcyBwcmVzZW50ZWQgaW5bM10uDQoNClRoYW5rcywNCg0KSm9uYXRoYW4NCg0K WzFdIA0KaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVzc2FnZS1pZC9mbGF0LzIwMjIw NjE2MjMzMTMwLnJwYXJpdmFmaXB0NmRvajMlNDBhbGFwMy5hbmFyYXplbC5kZQ0KWzJdIGh0 dHBzOi8vd2lraS5wb3N0Z3Jlc3FsLm9yZy93aWtpL1Bvc3RncmVTUUxfMTVfT3Blbl9JdGVt cw0KWzNdIA0KaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVzc2FnZS1pZC83ODdjZWY0 NS0xNWRlLThmMWQtZWQ1OC1hMWMxNDM1YmZjMGUlNDBwb3N0Z3Jlc3FsLm9yZw0K --------------ZU6cLCD5R9bICUh4swCN8yLF-- --------------c7axBuUX72TCiU82AMsCqGta 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/x8QSccp8cZScFAmLyypAFAwAAAAAACgkQ8QSccp8cZSd8 7w/+I8EpisoE9JYfHgIyxk5ysSw+3pc/oDuQTxbxbwR+qv48+6rVDwsb0SmNXMFHLSTD3ZtCOIMQ Rd/wkIG1w/1xz3FEdPjCgwsewpgDWBxuRqbwXRisLSNnDeBhcuMfnHQVNAcB9PAcDtiJ4Lh8T4+4 nzyiTKL6vsMU48g7u1OqQ0p4saHd/GAy2UoaTjsxqZ/7XoOo6x/dxAbcDOpw2NGcmRGkAbXXLxtf DEibln6S9+p94FM26d5bjP35aK01dX52mGC/zQ6+Lw9ObnEcldqXEgdRdiIkW20UQaeehuqZzt7T yx8tDnQP1QlBl88ShgyMYr/pnxbnUfcEg/t3BbS3XANgeR5WEu1APXkj3X2eDrtUzj7M04tqjpxm 8dt8cszgtflbCbSVsxLrlFAjyu6ppbAwoo1rEvoOoN0Kz8nw9bd+e/tH9sX2mw2hbXVEIgo0Q9PA MF1BNcu/lcyHvvw/s/qiObPzMLNE8vDnrzePQZyVMQT5TRZW/CkgLIUgRzQCB9xdILZ5w7EcXQc6 PHarlXWHHsMkqEZo9clB+FJyvLpQNXXDUoJQYK+odAxrXRAS4/KjiLMkqCHWpvlGDEt7dppO/zwm 3w6g5VmlyBoJrsWYl8rGenjKGwWFYZwtbPJsUsDliXYOLviqHNM4YR0mqvpyBQLM4SmrwORfV9L0 NM0= =1Cct -----END PGP SIGNATURE----- --------------c7axBuUX72TCiU82AMsCqGta--