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 1na0jv-0000HO-I2 for pgsql-committers@arkaria.postgresql.org; Thu, 31 Mar 2022 19:45:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1na0ju-000712-CU for pgsql-committers@arkaria.postgresql.org; Thu, 31 Mar 2022 19:45:50 +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 1na0ju-0006tg-4K for pgsql-committers@lists.postgresql.org; Thu, 31 Mar 2022 19:45:50 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1na0jr-0000FA-JE for pgsql-committers@lists.postgresql.org; Thu, 31 Mar 2022 19:45:49 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1na0jp-00076W-Eq for pgsql-committers@lists.postgresql.org; Thu, 31 Mar 2022 19:45:45 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1na0jn-000COS-SU for pgsql-committers@lists.postgresql.org; Thu, 31 Mar 2022 19:45:44 +0000 Content-Type: multipart/mixed; boundary="===============7450931428626485234==" MIME-Version: 1.0 From: Andrew Dunstan To: pgsql-committers@lists.postgresql.org Subject: pgsql: RETURNING clause for JSON() and JSON_SCALAR() X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 31 Mar 2022 19:45:44 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7450931428626485234== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UkVUVVJOSU5HIGNsYXVzZSBmb3IgSlNPTigpIGFuZCBKU09OX1NDQUxBUigpCgpUaGlzIHBhdGNo IGlzIGV4dHJhY3RlZCBmcm9tIGEgbGFyZ2VyIHBhdGNoIHRoYXQgYWxsb3dlZCBzZXR0aW5nIHRo ZQpkZWZhdWx0IHJldHVybmVkIHZhbHVlIGZyb20gdGhlc2UgZnVuY3Rpb25zIHRvIGpzb24gb3Ig anNvbmIuIFRoYXQgaGFkCnByb2JsZW1zLCBidXQgdGhpcyBwaWVjZSBvZiBpdCBpcyBmaW5lLiBG b3IgdGhlc2UgZnVuY3Rpb25zIG9ubHkganNvbiBvcgpqc29uYiBjYW4gYmUgc3BlY2lmaWVkIGlu IHRoZSBSRVRVUk5JTkcgY2xhdXNlLgoKRXh0cmFjdGVkIGZyb20gYW4gb3JpZ2luYWwgcGF0Y2gg ZnJvbSBOaWtpdGEgR2x1a2hvdgoKUmV2aWV3ZXJzIGhhdmUgaW5jbHVkZWQgKGluIG5vIHBhcnRp Y3VsYXIgb3JkZXIpIEFuZHJlcyBGcmV1bmQsIEFsZXhhbmRlcgpLb3JvdGtvdiwgUGF2ZWwgU3Rl aHVsZSwgQW5kcmV3IEFsc3VwLCBFcmlrIFJpamtlcnMsIFppaG9uZyBZdSwKSGltYW5zaHUgVXBh ZGh5YXlhLCBEYW5pZWwgR3VzdGFmc3NvbiwgSnVzdGluIFByeXpieS4KCkRpc2N1c3Npb246IGh0 dHBzOi8vcG9zdGdyLmVzL20vY2QwYmI5MzUtMDE1OC03OGE3LTA4YjUtOTA0ODg2ZGVhYzRiQHBv c3RncmVzcHJvLnJ1CgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBz Oi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvNDkwODJjMmNjM2Q4MTY3Y2NhNzBj ZmU2OTdhZmIwNjQ3MTA4MjhjYQoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2Jh Y2tlbmQvbm9kZXMvY29weWZ1bmNzLmMgICAgICAgICB8ICAyICsrCnNyYy9iYWNrZW5kL25vZGVz L2VxdWFsZnVuY3MuYyAgICAgICAgfCAgMiArKwpzcmMvYmFja2VuZC9ub2Rlcy9ub2RlRnVuY3Mu YyAgICAgICAgIHwgMjAgKysrKysrKysrKy0tCnNyYy9iYWNrZW5kL3BhcnNlci9ncmFtLnkgICAg ICAgICAgICAgfCAgNyArKystLQpzcmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfZXhwci5jICAgICAg IHwgNDYgKysrKysrKysrKysrKysrKysrKysrKy0tLS0tLQpzcmMvYmFja2VuZC91dGlscy9hZHQv cnVsZXV0aWxzLmMgICAgIHwgIDUgKy0tCnNyYy9pbmNsdWRlL25vZGVzL3BhcnNlbm9kZXMuaCAg ICAgICAgfCAgMiArKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3NxbGpzb24ub3V0IHwgNTcg KysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwv c3FsanNvbi5zcWwgICAgICB8IDEwICsrKysrKwo5IGZpbGVzIGNoYW5nZWQsIDEzNSBpbnNlcnRp b25zKCspLCAxNiBkZWxldGlvbnMoLSkKCg== --===============7450931428626485234==--