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 1nZIuT-0000tY-1p for pgsql-committers@arkaria.postgresql.org; Tue, 29 Mar 2022 20:57:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nZIuR-0001El-Jv for pgsql-committers@arkaria.postgresql.org; Tue, 29 Mar 2022 20:57:47 +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 1nZIuR-0001Ec-Ca for pgsql-committers@lists.postgresql.org; Tue, 29 Mar 2022 20:57:47 +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 1nZIuK-00021b-6m for pgsql-committers@lists.postgresql.org; Tue, 29 Mar 2022 20:57:46 +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 1nZIuI-0000l6-MU for pgsql-committers@lists.postgresql.org; Tue, 29 Mar 2022 20:57:38 +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 1nZIuG-001xDg-KJ for pgsql-committers@lists.postgresql.org; Tue, 29 Mar 2022 20:57:37 +0000 Content-Type: multipart/mixed; boundary="===============2180427016474611442==" MIME-Version: 1.0 From: Andrew Dunstan To: pgsql-committers@lists.postgresql.org Subject: pgsql: SQL/JSON query functions X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 29 Mar 2022 20:57:37 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2180427016474611442== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U1FML0pTT04gcXVlcnkgZnVuY3Rpb25zCgpUaGlzIGludHJvZHVjZXMgdGhlIFNRTC9KU09OIGZ1 bmN0aW9ucyBmb3IgcXVlcnlpbmcgSlNPTiBkYXRhIHVzaW5nCmpzb25wYXRoIGV4cHJlc3Npb25z LiBUaGUgZnVuY3Rpb25zIGFyZToKCkpTT05fRVhJU1RTKCkKSlNPTl9RVUVSWSgpCkpTT05fVkFM VUUoKQoKQWxsIG9mIHRoZXNlIGZ1bmN0aW9ucyBvbmx5IG9wZXJhdGUgb24ganNvbmIuIFRoZSB3 b3JrYXJvdW5kIGZvciBub3cgaXMKdG8gY2FzdCB0aGUgYXJndW1lbnQgdG8ganNvbmIuCgpKU09O X0VYSVNUUygpIHRlc3RzIGlmIHRoZSBqc29ucGF0aCBleHByZXNzaW9uIGFwcGxpZWQgdG8gdGhl IGpzb25iCnZhbHVlIHlpZWxkcyBhbnkgdmFsdWVzLiBKU09OX1ZBTFVFKCkgbXVzdCByZXR1cm4g YSBzaW5nbGUgdmFsdWUsIGFuZCBhbgplcnJvciBvY2N1cnMgaWYgaXQgdHJpZXMgdG8gcmV0dXJu IG11bHRpcGxlIHZhbHVlcy4gSlNPTl9RVUVSWSgpIG11c3QKcmV0dXJuIGEganNvbiBvYmplY3Qg b3IgYXJyYXksIGFuZCB0aGVyZSBhcmUgdmFyaW91cyBXUkFQUEVSIG9wdGlvbnMgZm9yCmhhbmRs aW5nIHNjYWxhciBvciBtdWx0aS12YWx1ZSByZXN1bHRzLiBCb3RoIHRoZXNlIGZ1bmN0aW9ucyBo YXZlCm9wdGlvbnMgZm9yIGhhbmRsaW5nIEVNUFRZIGFuZCBFUlJPUiBjb25kaXRpb25zLgoKTmlr aXRhIEdsdWtob3YKClJldmlld2VycyBoYXZlIGluY2x1ZGVkIChpbiBubyBwYXJ0aWN1bGFyIG9y ZGVyKSBBbmRyZXMgRnJldW5kLCBBbGV4YW5kZXIKS29yb3Rrb3YsIFBhdmVsIFN0ZWh1bGUsIEFu ZHJldyBBbHN1cCwgRXJpayBSaWprZXJzLCBaaWhvbmcgWXUsCkhpbWFuc2h1IFVwYWRoeWF5YSwg RGFuaWVsIEd1c3RhZnNzb24sIEp1c3RpbiBQcnl6YnkuCgpEaXNjdXNzaW9uOiBodHRwczovL3Bv c3Rnci5lcy9tL2NkMGJiOTM1LTAxNTgtNzhhNy0wOGI1LTkwNDg4NmRlYWM0YkBwb3N0Z3Jlc3By by5ydQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5w b3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzFhMzZiYzlkYmE4ZWFlOTA5NjNhNTg2ZDM3YjY0 NTdiMzJiMmZlZDQKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2V4 ZWN1dG9yL2V4ZWNFeHByLmMgICAgICAgICAgICAgfCAgMjA2ICsrKystLQpzcmMvYmFja2VuZC9l eGVjdXRvci9leGVjRXhwckludGVycC5jICAgICAgIHwgIDU0MyArKysrKysrKysrKysrKwpzcmMv YmFja2VuZC9qaXQvbGx2bS9sbHZtaml0X2V4cHIuYyAgICAgICAgIHwgICAgNiArCnNyYy9iYWNr ZW5kL2ppdC9sbHZtL2xsdm1qaXRfdHlwZXMuYyAgICAgICAgfCAgICAxICsKc3JjL2JhY2tlbmQv bm9kZXMvY29weWZ1bmNzLmMgICAgICAgICAgICAgICB8ICAxNTAgKysrKwpzcmMvYmFja2VuZC9u b2Rlcy9lcXVhbGZ1bmNzLmMgICAgICAgICAgICAgIHwgIDEyNyArKysrCnNyYy9iYWNrZW5kL25v ZGVzL21ha2VmdW5jcy5jICAgICAgICAgICAgICAgfCAgIDE1ICsKc3JjL2JhY2tlbmQvbm9kZXMv bm9kZUZ1bmNzLmMgICAgICAgICAgICAgICB8ICAxODYgKysrKy0Kc3JjL2JhY2tlbmQvbm9kZXMv b3V0ZnVuY3MuYyAgICAgICAgICAgICAgICB8ICAgNzAgKysKc3JjL2JhY2tlbmQvbm9kZXMvcmVh ZGZ1bmNzLmMgICAgICAgICAgICAgICB8ICAgODYgKysrCnNyYy9iYWNrZW5kL29wdGltaXplci9w YXRoL2Nvc3RzaXplLmMgICAgICAgfCAgICAzICstCnNyYy9iYWNrZW5kL29wdGltaXplci91dGls L2NsYXVzZXMuYyAgICAgICAgfCAgIDMyICsKc3JjL2JhY2tlbmQvcGFyc2VyL2dyYW0ueSAgICAg ICAgICAgICAgICAgICB8ICAzMzMgKysrKysrKystCnNyYy9iYWNrZW5kL3BhcnNlci9wYXJzZV9j b2xsYXRlLmMgICAgICAgICAgfCAgICA0ICsKc3JjL2JhY2tlbmQvcGFyc2VyL3BhcnNlX2V4cHIu YyAgICAgICAgICAgICB8ICA0OTAgKysrKysrKysrKysrLQpzcmMvYmFja2VuZC9wYXJzZXIvcGFy c2VfdGFyZ2V0LmMgICAgICAgICAgIHwgICAxNSArCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9mb3Jt YXR0aW5nLmMgICAgICAgICAgfCAgIDQ1ICstCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9qc29uYi5j ICAgICAgICAgICAgICAgfCAgIDYyICsrCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9qc29uZnVuY3Mu YyAgICAgICAgICAgfCAgIDUwICstCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9qc29ucGF0aC5jICAg ICAgICAgICAgfCAgMjU3ICsrKysrKysKc3JjL2JhY2tlbmQvdXRpbHMvYWR0L2pzb25wYXRoX2V4 ZWMuYyAgICAgICB8ICAzNTAgKysrKysrKy0tCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9ydWxldXRp bHMuYyAgICAgICAgICAgfCAgMTM1ICsrKysKc3JjL2JhY2tlbmQvdXRpbHMvbWlzYy9xdWVyeWp1 bWJsZS5jICAgICAgICB8ICAgMjEgKwpzcmMvaW5jbHVkZS9leGVjdXRvci9leGVjRXhwci5oICAg ICAgICAgICAgIHwgICA1NCArKwpzcmMvaW5jbHVkZS9leGVjdXRvci9leGVjdXRvci5oICAgICAg ICAgICAgIHwgICAgMiArCnNyYy9pbmNsdWRlL25vZGVzL21ha2VmdW5jcy5oICAgICAgICAgICAg ICAgfCAgICAxICsKc3JjL2luY2x1ZGUvbm9kZXMvbm9kZXMuaCAgICAgICAgICAgICAgICAgICB8 ICAgIDcgKwpzcmMvaW5jbHVkZS9ub2Rlcy9wYXJzZW5vZGVzLmggICAgICAgICAgICAgIHwgICA1 OSArKwpzcmMvaW5jbHVkZS9ub2Rlcy9wcmltbm9kZXMuaCAgICAgICAgICAgICAgIHwgIDEwOSAr KysKc3JjL2luY2x1ZGUvcGFyc2VyL2t3bGlzdC5oICAgICAgICAgICAgICAgICB8ICAgMTEgKwpz cmMvaW5jbHVkZS91dGlscy9mb3JtYXR0aW5nLmggICAgICAgICAgICAgIHwgICAgNCArCnNyYy9p bmNsdWRlL3V0aWxzL2pzb25iLmggICAgICAgICAgICAgICAgICAgfCAgICAzICsKc3JjL2luY2x1 ZGUvdXRpbHMvanNvbmZ1bmNzLmggICAgICAgICAgICAgICB8ICAgIDQgKwpzcmMvaW5jbHVkZS91 dGlscy9qc29ucGF0aC5oICAgICAgICAgICAgICAgIHwgICAzMyArCnNyYy90ZXN0L3JlZ3Jlc3Mv ZXhwZWN0ZWQvanNvbl9zcWxqc29uLm91dCAgfCAgIDE1ICsKc3JjL3Rlc3QvcmVncmVzcy9leHBl Y3RlZC9qc29uYl9zcWxqc29uLm91dCB8IDEwMTggKysrKysrKysrKysrKysrKysrKysrKysrKysr CnNyYy90ZXN0L3JlZ3Jlc3MvcGFyYWxsZWxfc2NoZWR1bGUgICAgICAgICAgfCAgICAyICstCnNy Yy90ZXN0L3JlZ3Jlc3Mvc3FsL2pzb25fc3FsanNvbi5zcWwgICAgICAgfCAgIDExICsKc3JjL3Rl c3QvcmVncmVzcy9zcWwvanNvbmJfc3FsanNvbi5zcWwgICAgICB8ICAzMTcgKysrKysrKysrCjM5 IGZpbGVzIGNoYW5nZWQsIDQ3MTYgaW5zZXJ0aW9ucygrKSwgMTIxIGRlbGV0aW9ucygtKQoK --===============2180427016474611442==--