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 1oT2JW-0000KD-2T for pgsql-hackers@arkaria.postgresql.org; Tue, 30 Aug 2022 14:34: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 1oT2JU-0007tJ-Ru for pgsql-hackers@arkaria.postgresql.org; Tue, 30 Aug 2022 14:34:00 +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 1oT2JU-0007t6-FP for pgsql-hackers@lists.postgresql.org; Tue, 30 Aug 2022 14:34:00 +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 1oT2JR-0000P7-J0 for pgsql-hackers@lists.postgresql.org; Tue, 30 Aug 2022 14:34:00 +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=HI7FmMC9WBOqFLbLE6TOeKDFTnmwi6c3EkAfZv3Af24=; b=OpHIzqYnUutEMoWQTMePC4PqfW fiVuYWABaR352ATiRBMdePcSill4cT+6gdSyf9Iz0dCFNlblFS+rkE3L1yHCNyuzPQELL+7JlIVa+ 35hvttBKJy+91Nw2qJessgYUOwbwcI6o1VUosBFJrFPYdoQbdnoAWD1Xx8VHGrgFpRtBNk4HSgX9E fCZ80cD/JqWwWReNPDuVKcdspEaL61fkr6bK9MJaAZTaf4N2isEEAdv0aoOoMfXAv9DEvOyZM6MCI K9YKz0/bLWi68Xl3hpyfZ9HsoGkFg1nCfc7nkic9xvKwOcroMZVVu52dsOfCMf9dpt3UxDS0jA6DV LXIM/Duw==; 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 1oT2JK-0001YM-CR; Tue, 30 Aug 2022 14:33:52 +0000 Message-ID: Date: Tue, 30 Aug 2022 10:33:45 -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 , Amit Langote , Alvaro Herrera Cc: Nikita Glukhov , Tom Lane , Robert Haas , Andres Freund , PostgreSQL Hackers , Michael Paquier , John Naylor References: <20220830092008.6dbublx6la226zis@alvherre.pgsql> 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="------------4qv7Ah9jWLPXidq7qInQaf34" 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) --------------4qv7Ah9jWLPXidq7qInQaf34 Content-Type: multipart/mixed; boundary="------------8ankw7nWKpuvabboTL3PLTfb"; protected-headers="v1" From: "Jonathan S. Katz" To: Andrew Dunstan , Amit Langote , Alvaro Herrera Cc: Nikita Glukhov , Tom Lane , Robert Haas , Andres Freund , PostgreSQL Hackers , Michael Paquier , John Naylor Message-ID: Subject: Re: SQL/JSON features for v15 References: <20220830092008.6dbublx6la226zis@alvherre.pgsql> In-Reply-To: --------------8ankw7nWKpuvabboTL3PLTfb Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOC8zMC8yMiA5OjE2IEFNLCBBbmRyZXcgRHVuc3RhbiB3cm90ZToNCj4gDQo+IE9uIDIw MjItMDgtMzAgVHUgMDY6MjksIEFtaXQgTGFuZ290ZSB3cm90ZToNCj4+IE9uIFR1ZSwgQXVn IDMwLCAyMDIyIGF0IDY6MTkgUE0gQWx2YXJvIEhlcnJlcmEgPGFsdmhlcnJlQGFsdmgubm8t aXAub3JnPiB3cm90ZToNCj4+PiBPbiAyMDIyLUF1Zy0zMCwgQW1pdCBMYW5nb3RlIHdyb3Rl Og0KPj4+DQo+Pj4+IFBhdGNoZXMgMDAwMS0wMDA2Og0KPj4+Pg0KPj4+PiBZZWFoLCB0aGVz ZSBhZGQgdGhlIG92ZXJoZWFkIG9mIGFuIGV4dHJhIGZ1bmN0aW9uIGNhbGwgKHR5cGluKCkg LT4NCj4+Pj4gdHlwaW5fb3B0X2Vycm9yKCkpIGluIHBvc3NpYmx5IHZlcnkgY29tbW9uIHBh dGhzLiAgT3RoZXIgdGhhbg0KPj4+PiByZWZhY3RvcmluZyAqYWxsKiBwbGFjZXMgdGhhdCBj YWxsIHR5cGluKCkgdG8gdXNlIHRoZSBuZXcgQVBJLCB0aGUNCj4+Pj4gb25seSBvdGhlciBv cHRpb24gc2VlbXMgdG8gYmUgdG8gbGVhdmUgdGhlIHR5cGluKCkgZnVuY3Rpb25zIGFsb25l IGFuZA0KPj4+PiBkdXBsaWNhdGUgdGhlaXIgY29kZSBpbiB0eXBpbl9vcHRfZXJyb3IoKSB2 ZXJzaW9ucyBmb3IgYWxsIHRoZSB0eXBlcw0KPj4+PiB0aGF0IHRoaXMgcGF0Y2ggY2FyZXMg YWJvdXQuICBUaG91Z2ggbWF5YmUsIHRoYXQncyBub3QgbmVjZXNzYXJpbHkgYQ0KPj4+PiBi ZXR0ZXIgY29tcHJvbWlzZSB0aGFuIGFjY2VwdGluZyB0aGUgZXh0cmEgZnVuY3Rpb24gY2Fs bCBvdmVyaGVhZC4NCj4+PiBJIHRoaW5rIGFub3RoZXIgcG9zc2liaWxpdHkgaXMgdG8gY3Jl YXRlIGEgc3RhdGljIGlubGluZSBmdW5jdGlvbiBpbiB0aGUNCj4+PiBjb3JyZXNwb25kaW5n IC5jIG1vZHVsZSAoc2F5IGJvb2xpbl9pbXBsKCkgaW4gYm9vbC5jKSwgd2hpY2ggaXMgY2Fs bGVkDQo+Pj4gYnkgYm90aCB0aGUgb3B0X2Vycm9yIHZhcmlhbnQgYXMgd2VsbCBhcyB0aGUg cmVndWxhciBvbmUuICBUaGlzIHdvdWxkDQo+Pj4gYXZvaWQgdGhlIGR1cGxpY2F0ZSBjb2Rl IGFzIHdlbGwgYXMgdGhlIGFkZGVkIGZ1bmN0aW9uLWNhbGwgb3ZlcmhlYWQuDQo+PiArMQ0K Pj4NCj4gDQo+IE1ha2VzIHBsZW50eSBvZiBzZW5zZSwgSSdsbCB0cnkgdG8gY29tZSB1cCB3 aXRoIHJlcGxhY2VtZW50cyBmb3IgdGhlc2UNCj4gZm9ydGh3aXRoLg0KDQpUaGUgUk1UIGhh ZCBpdHMgd2Vla2x5IG1lZXRpbmcgdG9kYXkgdG8gZGlzY3VzcyBvcGVuIGl0ZW1zLiBBcyBz dGF0ZWQgDQpsYXN0IHdlZWssIHRvIGtlZXAgdGhlIHYxNSByZWxlYXNlIHdpdGhpbiBhIGxh dGUgU2VwdCAvIGVhcmx5IE9jdCANCnRpbWVmcmFtZSwgd2UgbmVlZCB0byBtYWtlIGEgZGVj aXNpb24gYWJvdXQgdGhlIGluY2x1c2lvbiBvZiBTUUwvSlNPTiANCnRoaXMgd2Vlay4NCg0K Rmlyc3QsIHdlIGFwcHJlY2lhdGUgYWxsIG9mIHRoZSBlZmZvcnQgYW5kIHdvcmsgdGhhdCBo YXMgZ29uZSBpbnRvIA0KaW5jb3Jwb3JhdGluZyBjb21tdW5pdHkgZmVlZGJhY2sgaW50byB0 aGUgcGF0Y2hlcy4gV2UgZGlkIG5vdGUgdGhhdCANCmZvbGtzIHdvcmtpbmcgb24gdGhpcyBt YWRlIGEgbG90IG9mIHByb2dyZXNzIG92ZXIgdGhlIHBhc3Qgd2Vlay4NCg0KVGhlIFJNVCBz dGlsbCBoYXMgYSBmZXcgY29uY2VybnMsIHN1bW1hcml6ZWQgYXM6DQoNCjEuIFRoZXJlIGlz IG5vdCB5ZXQgY29uc2Vuc3VzIG9uIHRoZSBjdXJyZW50IHBhdGNoIHByb3Bvc2FscyBhcyB3 ZSANCmFwcHJvYWNoIHRoZSBlbmQgb2YgdGhlIG1ham9yIHJlbGVhc2UgY3ljbGUNCjIuIFRo ZXJlIGlzIGEgbGFjayBvZiBnZW5lcmFsIGZlZWRiYWNrIGZyb20gZm9sa3Mgd2hvIHJhaXNl ZCBjb25jZXJucyANCmFib3V0IHRoZSBpbXBsZW1lbnRhdGlvbg0KDQpUaGUgUk1UIGlzIHN0 aWxsIGluY2xpbmVkIHRvIHJldmVydCwgYnV0IHdpbGwgZ2l2ZSBmb2xrcyB1bnRpbCBTZXAg MSANCjA6MDAgQW9FWzFdIHRvIHJlYWNoIGNvbnNlbnN1cyBvbiBpZiBTUUwvSlNPTiBjYW4g YmUgaW5jbHVkZWQgaW4gdjE1LiANClRoaXMgbWF0Y2hlcyB1cCB0byBBbmRyZXcncyBhdmFp bGFiaWxpdHkgdGltZWxpbmUgZm9yIGEgcmV2ZXJ0LCBhbmQgDQpnaXZlcyBlbm91Z2ggdGlt ZSB0byBnZXQgdGhyb3VnaCB0aGUgYnVpbGRmYXJtIHByaW9yIHRvIHRoZSBCZXRhIDQgDQpy ZWxlYXNlWzJdLg0KDQpBZnRlciB0aGUgZGVhZGxpbmUsIGlmIHRoZXJlIGlzIG5vIGNvbnNl bnN1cyBvbiBob3cgdG8gcHJvY2VlZCwgdGhlIFJNVCANCndpbGwgcmVxdWVzdCB0aGF0IHRo ZSBwYXRjaGVzIGFyZSByZXZlcnRlZC4NCg0KV2hpbGUgbm90aW5nIHRoYXQgdGhpcyBSTVQg aGFzIG5vIGRlY2lzaW9uIG1ha2luZyBvdmVyIHYxNiwgaW4gdGhlIGV2ZW50IA0Kb2YgYSBy ZXZlcnQgd2UgZG8gaG9wZSB0aGlzIHJlY2VudCB3b3JrIGNhbiBiZSB0aGUgYmFzaXMgb2Yg dGhlIGZlYXR1cmUgDQppbiB2MTYuDQoNCkFnYWluLCB3ZSBhcHByZWNpYXRlIHRoZSBlZmZv cnRzIHRoYXQgaGF2ZSBnb25lIGludG8gYWRkcmVzc2luZyB0aGUgDQpjb21tdW5pdHkgZmVl ZGJhY2suDQoNClNpbmNlcmVseSwNCg0KSm9obiwgSm9uYXRoYW4sIE1pY2hhZWwNCg0KWzFd IGh0dHBzOi8vZW4ud2lraXBlZGlhLm9yZy93aWtpL0FueXdoZXJlX29uX0VhcnRoDQpbMl0g DQpodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tZXNzYWdlLWlkLzlkMjUxYWVjLWNlYTIt YmMxYS01ZWQ4LTQ2ZWYwYmNmNmM2OUBwb3N0Z3Jlc3FsLm9yZw0K --------------8ankw7nWKpuvabboTL3PLTfb-- --------------4qv7Ah9jWLPXidq7qInQaf34 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/x8QSccp8cZScFAmMOH8kFAwAAAAAACgkQ8QSccp8cZSdS fw/7B/1m88Mf7Pbklu1YJEfn/c7mIorasAHdQoU0HheuAsogZFmWu9zWTsISvomjLfL17scLPhB8 EJpt53VA8Kv74Tp681eCwNjs2teidz+YPEVx8hjB5Jy2WIlY87Ms5nSzvM5vTVTKGMw6MdwZxVj7 S7VOCv8cU+aicBtMYe0A1iwRZpzBFbk9icpVLo4SoHh2Cp/fvcobEIY6FBphK3frUl7f8o4PeD6w ku4ZmRtC02UJyZ6oBm240HcY0puVnvjmJvbNxGPKuAhgyYMLPB4Stevs/rFzad9tiAbcadD7TCMy cRSGuNEnE2g9hRzeLo6Om21ps8h1QFnPS8/EKQHu97uZKSAXbSl5SjKCFXFE3EeIbLcdT7pW+8aj St8ZKkhp/nM9qkYXfy8neqI9kuEDnS0Kd/0nr11hUhxpMPBYufTDen2DN9AhesPeFUhxAFgVkVlS pRYvgsBe286kfV/gITjA1FdLi1Jzw51OKJZTIRYwyIlcu7Q+jSF94JyfosfmJE1/WmoMrseGFHo3 MnV0Km+8MiGrcrhhzIZ/bl2VxhKICVHAncoGWizDtasQVhY1+9gF8OLUvhM2a6hjzObDrD8yczbQ endLGjL3C7JW+/shN7btlzWYs05pN86LJe+DgOncuRUmPncZesmBtyAd1EqMm3Nf+KT6glVyEScY MMY= =MYTc -----END PGP SIGNATURE----- --------------4qv7Ah9jWLPXidq7qInQaf34--