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 1phSo5-0005Hh-GZ for pgsql-committers@arkaria.postgresql.org; Wed, 29 Mar 2023 10:13:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1phSo4-0005pR-Eo for pgsql-committers@arkaria.postgresql.org; Wed, 29 Mar 2023 10:13:28 +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 1phSo4-0005pI-7t for pgsql-committers@lists.postgresql.org; Wed, 29 Mar 2023 10:13:28 +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 1phSo1-0002lS-0l for pgsql-committers@lists.postgresql.org; Wed, 29 Mar 2023 10:13:27 +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 1phSnz-0000U5-4w for pgsql-committers@lists.postgresql.org; Wed, 29 Mar 2023 10:13:23 +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 1phSnx-000IYc-43 for pgsql-committers@lists.postgresql.org; Wed, 29 Mar 2023 10:13:22 +0000 Content-Type: multipart/mixed; boundary="===============6385510384001831250==" MIME-Version: 1.0 From: Alvaro Herrera To: pgsql-committers@lists.postgresql.org Subject: pgsql: SQL/JSON: add standard JSON constructor functions X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 29 Mar 2023 10:13:22 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6385510384001831250== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U1FML0pTT046IGFkZCBzdGFuZGFyZCBKU09OIGNvbnN0cnVjdG9yIGZ1bmN0aW9ucwoKVGhpcyBj b21taXQgaW50cm9kdWNlcyB0aGUgU1FML0pTT04gc3RhbmRhcmQtY29uZm9ybWluZyBjb25zdHJ1 Y3RvcnMgZm9yCkpTT04gdHlwZXM6CgpKU09OX0FSUkFZKCkKSlNPTl9BUlJBWUFHRygpCkpTT05f T0JKRUNUKCkKSlNPTl9PQkpFQ1RBR0coKQoKTW9zdCBvZiB0aGUgZnVuY3Rpb25hbGl0eSB3YXMg YWxyZWFkeSBwcmVzZW50IGluIFBvc3RncmVTUUwtc3BlY2lmaWMKZnVuY3Rpb25zLCBidXQgdGhl c2UgaW5jbHVkZSBzb21lIG5ldyBmdW5jdGlvbmFsaXR5IHN1Y2ggYXMgdGhlIGFiaWxpdHkKdG8g c2tpcCBvciBpbmNsdWRlIE5VTEwgdmFsdWVzLCBhbmQgdG8gYWxsb3cgZHVwbGljYXRlIGtleXMg b3IgdGhyb3cKZXJyb3Igd2hlbiB0aGV5IGFyZSBmb3VuZCwgYXMgd2VsbCBhcyB0aGUgc3RhbmRh cmQgc3BlY2lmaWVkIHN5bnRheCB0bwpzcGVjaWZ5IG91dHB1dCB0eXBlIGFuZCBmb3JtYXQuCgpB dXRob3I6IE5pa2l0YSBHbHVraG92IDxuLmdsdWhvdkBwb3N0Z3Jlc3Byby5ydT4KQXV0aG9yOiBU ZW9kb3IgU2lnYWV2IDx0ZW9kb3JAc2lnYWV2LnJ1PgpBdXRob3I6IE9sZWcgQmFydHVub3YgPG9i YXJ0dW5vdkBnbWFpbC5jb20+CkF1dGhvcjogQWxleGFuZGVyIEtvcm90a292IDxhZWtvcm90a292 QGdtYWlsLmNvbT4KQXV0aG9yOiBBbWl0IExhbmdvdGUgPGFtaXRsYW5nb3RlMDlAZ21haWwuY29t PgoKUmV2aWV3ZXJzIGhhdmUgaW5jbHVkZWQgKGluIG5vIHBhcnRpY3VsYXIgb3JkZXIpIEFuZHJl cyBGcmV1bmQsIEFsZXhhbmRlcgpLb3JvdGtvdiwgUGF2ZWwgU3RlaHVsZSwgQW5kcmV3IEFsc3Vw LCBFcmlrIFJpamtlcnMsIFppaG9uZyBZdSwKSGltYW5zaHUgVXBhZGh5YXlhLCBEYW5pZWwgR3Vz dGFmc3NvbiwgSnVzdGluIFByeXpieS4KCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20v Q0FGNEF1NHcyeC01TFRuTl9ieGt5LW1xND1XT3FzR3N4U3BFTkN6SFJBelNuRWQ4K1dRQG1haWwu Z21haWwuY29tCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vY2QwYmI5MzUtMDE1OC03 OGE3LTA4YjUtOTA0ODg2ZGVhYzRiQHBvc3RncmVzcHJvLnJ1CkRpc2N1c3Npb246IGh0dHBzOi8v cG9zdGdyLmVzL20vMjAyMjA2MTYyMzMxMzAucnBhcml2YWZpcHQ2ZG9qM0BhbGFwMy5hbmFyYXpl bC5kZQpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL2FiZDliODNiLWFhNjYtZjIzMC0z ZDZkLTczNDgxN2YwOTk1ZCU0MHBvc3RncmVzcWwub3JnCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoK RGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYv NzA4MWFjNDZhY2U4YzQ1OTk2NjE3NDQwMGI1MzQxODY4M2M5ZmU1YwoKTW9kaWZpZWQgRmlsZXMK LS0tLS0tLS0tLS0tLS0KZG9jL3NyYy9zZ21sL2Z1bmMuc2dtbCAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgfCAyODYgKysrKysrKy0Kc3JjL2JhY2tlbmQvZXhlY3V0b3IvZXhlY0V4cHIuYyAg ICAgICAgICAgICAgICAgICAgfCAgOTEgKysrCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2V4ZWNFeHBy SW50ZXJwLmMgICAgICAgICAgICAgIHwgIDUwICsrCnNyYy9iYWNrZW5kL2ppdC9sbHZtL2xsdm1q aXRfZXhwci5jICAgICAgICAgICAgICAgIHwgICA2ICsKc3JjL2JhY2tlbmQvaml0L2xsdm0vbGx2 bWppdF90eXBlcy5jICAgICAgICAgICAgICAgfCAgIDEgKwpzcmMvYmFja2VuZC9ub2Rlcy9tYWtl ZnVuY3MuYyAgICAgICAgICAgICAgICAgICAgICB8ICA2OSArKwpzcmMvYmFja2VuZC9ub2Rlcy9u b2RlRnVuY3MuYyAgICAgICAgICAgICAgICAgICAgICB8IDIyMSArKysrKysKc3JjL2JhY2tlbmQv b3B0aW1pemVyL3V0aWwvY2xhdXNlcy5jICAgICAgICAgICAgICAgfCAgNTUgKysKc3JjL2JhY2tl bmQvcGFyc2VyL2dyYW0ueSAgICAgICAgICAgICAgICAgICAgICAgICAgfCAyNTcgKysrKysrLQpz cmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfZXhwci5jICAgICAgICAgICAgICAgICAgICB8IDc3MCAr KysrKysrKysrKysrKysrKysrKysKc3JjL2JhY2tlbmQvcGFyc2VyL3BhcnNlX3RhcmdldC5jICAg ICAgICAgICAgICAgICAgfCAgMTggKwpzcmMvYmFja2VuZC9wYXJzZXIvcGFyc2VyLmMgICAgICAg ICAgICAgICAgICAgICAgICB8ICAyNiArCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9qc29uLmMgICAg ICAgICAgICAgICAgICAgICAgIHwgNDM0ICsrKysrKysrKystLQpzcmMvYmFja2VuZC91dGlscy9h ZHQvanNvbmIuYyAgICAgICAgICAgICAgICAgICAgICB8IDIzNiArKysrKy0tCnNyYy9iYWNrZW5k L3V0aWxzL2FkdC9qc29uYl91dGlsLmMgICAgICAgICAgICAgICAgIHwgIDU2ICstCnNyYy9iYWNr ZW5kL3V0aWxzL2FkdC9ydWxldXRpbHMuYyAgICAgICAgICAgICAgICAgIHwgMjc1ICsrKysrKyst CnNyYy9pbmNsdWRlL2NhdGFsb2cvY2F0dmVyc2lvbi5oICAgICAgICAgICAgICAgICAgIHwgICAy ICstCnNyYy9pbmNsdWRlL2NhdGFsb2cvcGdfYWdncmVnYXRlLmRhdCAgICAgICAgICAgICAgIHwg IDIyICsKc3JjL2luY2x1ZGUvY2F0YWxvZy9wZ19wcm9jLmRhdCAgICAgICAgICAgICAgICAgICAg fCAgNzQgKysKc3JjL2luY2x1ZGUvZXhlY3V0b3IvZXhlY0V4cHIuaCAgICAgICAgICAgICAgICAg ICAgfCAgMjYgKwpzcmMvaW5jbHVkZS9ub2Rlcy9tYWtlZnVuY3MuaCAgICAgICAgICAgICAgICAg ICAgICB8ICAgNiArCnNyYy9pbmNsdWRlL25vZGVzL3BhcnNlbm9kZXMuaCAgICAgICAgICAgICAg ICAgICAgIHwgMTA3ICsrKwpzcmMvaW5jbHVkZS9ub2Rlcy9wcmltbm9kZXMuaCAgICAgICAgICAg ICAgICAgICAgICB8ICA4NSArKysKc3JjL2luY2x1ZGUvcGFyc2VyL2t3bGlzdC5oICAgICAgICAg ICAgICAgICAgICAgICAgfCAgIDggKwpzcmMvaW5jbHVkZS91dGlscy9qc29uLmggICAgICAgICAg ICAgICAgICAgICAgICAgICB8ICAgNiArCnNyYy9pbmNsdWRlL3V0aWxzL2pzb25iLmggICAgICAg ICAgICAgICAgICAgICAgICAgIHwgICA5ICsKc3JjL2ludGVyZmFjZXMvZWNwZy9wcmVwcm9jL3Bh cnNlLnBsICAgICAgICAgICAgICAgfCAgIDIgKwpzcmMvaW50ZXJmYWNlcy9lY3BnL3ByZXByb2Mv cGFyc2VyLmMgICAgICAgICAgICAgICB8ICAyMiArCnNyYy9pbnRlcmZhY2VzL2VjcGcvdGVzdC9l Y3BnX3NjaGVkdWxlICAgICAgICAgICAgIHwgICAxICsKc3JjL2ludGVyZmFjZXMvZWNwZy90ZXN0 L2V4cGVjdGVkL3NxbC1zcWxqc29uLmMgICAgfCAyMDMgKysrKysrCi4uLi9lY3BnL3Rlc3QvZXhw ZWN0ZWQvc3FsLXNxbGpzb24uc3RkZXJyICAgICAgICAgIHwgIDY5ICsrCi4uLi9lY3BnL3Rlc3Qv ZXhwZWN0ZWQvc3FsLXNxbGpzb24uc3Rkb3V0ICAgICAgICAgIHwgICA2ICsKc3JjL2ludGVyZmFj ZXMvZWNwZy90ZXN0L3NxbC9NYWtlZmlsZSAgICAgICAgICAgICAgfCAgIDEgKwpzcmMvaW50ZXJm YWNlcy9lY3BnL3Rlc3Qvc3FsL21lc29uLmJ1aWxkICAgICAgICAgICB8ICAgMSArCnNyYy9pbnRl cmZhY2VzL2VjcGcvdGVzdC9zcWwvc3FsanNvbi5wZ2MgICAgICAgICAgIHwgIDQ0ICsrCnNyYy90 ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvanNvbi5vdXQgICAgICAgICAgICAgICAgIHwgIDExICstCnNy Yy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvb3ByX3Nhbml0eS5vdXQgICAgICAgICAgIHwgICA2ICst CnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvc3FsanNvbi5vdXQgICAgICAgICAgICAgIHwgNzU2 ICsrKysrKysrKysrKysrKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3MvcGFyYWxsZWxfc2NoZWR1bGUg ICAgICAgICAgICAgICAgIHwgICAyICstCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL29wcl9zYW5pdHku c3FsICAgICAgICAgICAgICAgIHwgICA2ICstCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3NxbGpzb24u c3FsICAgICAgICAgICAgICAgICAgIHwgMjg0ICsrKysrKysrCnNyYy90b29scy9wZ2luZGVudC90 eXBlZGVmcy5saXN0ICAgICAgICAgICAgICAgICAgIHwgICAxICsKNDIgZmlsZXMgY2hhbmdlZCwg NDQ3MCBpbnNlcnRpb25zKCspLCAxNDEgZGVsZXRpb25zKC0pCgo= --===============6385510384001831250==--