Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rnDSh-00C8kA-As for pgsql-committers@arkaria.postgresql.org; Thu, 21 Mar 2024 08:07:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rnDSf-00BPJX-Db for pgsql-committers@arkaria.postgresql.org; Thu, 21 Mar 2024 08:07:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rnDSf-00BPJP-3v for pgsql-committers@lists.postgresql.org; Thu, 21 Mar 2024 08:07:41 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rnDSd-005gl0-GE for pgsql-committers@lists.postgresql.org; Thu, 21 Mar 2024 08:07:40 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=joxtNhLDwIyCI1ADJdKkBY2mA2rZPbgUcDu/gXMikpA=; b=ixOIbQQeK3sQJVFKpzHUiwgLK+ jWvepPmG5rTcifbM1mJH1+tRWeazz8Zrkz39TIFWgZwlskMUK/9Ja7QskevXQwCAZJi7nae837Il+ D+zxfQgiuqwBlhKUfucRZ5Kk5XUoTjDE1rKd7py8/9SJD5g2ZJjURCGon5dAJ5+4hAjAMrxmqDEn4 HBdvQe6Aw1CWqQADyd9iNReNHxYt3JmoEBdwquzQtXcaMuUgqlAolb93r3/5JOwaZpzd4X1jH4yuf rG68ARWNpyJjSYlyl39ByMhvTZhjLOkSzveaJzvsiJIL6P+xe5ZsMBeGqhQORfA5koM341RWiwgJm 2rW9mr0w==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rnDSb-00FTHO-Vo for pgsql-committers@lists.postgresql.org; Thu, 21 Mar 2024 08:07:37 +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 1rnDSa-004uGu-Kh for pgsql-committers@lists.postgresql.org; Thu, 21 Mar 2024 08:07:37 +0000 Content-Type: multipart/mixed; boundary="===============8496062448317871177==" MIME-Version: 1.0 From: Amit Langote To: pgsql-committers@lists.postgresql.org Subject: pgsql: Add SQL/JSON query functions X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 21 Mar 2024 08:07:37 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8496062448317871177== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRkIFNRTC9KU09OIHF1ZXJ5IGZ1bmN0aW9ucwoKVGhpcyBpbnRyb2R1Y2VzIHRoZSBmb2xsb3dp bmcgU1FML0pTT04gZnVuY3Rpb25zIGZvciBxdWVyeWluZyBKU09OCmRhdGEgdXNpbmcganNvbnBh dGggZXhwcmVzc2lvbnM6CgpKU09OX0VYSVNUUygpLCB3aGljaCBjYW4gYmUgdXNlZCB0byBhcHBs eSBhIGpzb25wYXRoIGV4cHJlc3Npb24gdG8gYQpKU09OIHZhbHVlIHRvIGNoZWNrIGlmIGl0IHlp ZWxkcyBhbnkgdmFsdWVzLgoKSlNPTl9RVUVSWSgpLCB3aGljaCBjYW4gYmUgdXNlZCB0byB0byBh cHBseSBhIGpzb25wYXRoIGV4cHJlc3Npb24gdG8KYSBKU09OIHZhbHVlIHRvIGdldCBhIEpTT04g b2JqZWN0LCBhbiBhcnJheSwgb3IgYSBzdHJpbmcuICBUaGVyZSBhcmUKdmFyaW91cyBvcHRpb25z IHRvIGNvbnRyb2wgd2hldGhlciBtdWx0aS12YWx1ZSByZXN1bHQgdXNlcyBhcnJheQp3cmFwcGVy cyBhbmQgd2hldGhlciB0aGUgc2luZ2xldG9uIHNjYWxhciBzdHJpbmdzIGFyZSBxdW90ZWQgb3Ig bm90LgoKSlNPTl9WQUxVRSgpLCB3aGljaCBjYW4gYmUgdXNlZCB0byBhcHBseSBhIGpzb25wYXRo IGV4cHJlc3Npb24gdG8gYQpKU09OIHZhbHVlIHRvIHJldHVybiBhIHNpbmdsZSBzY2FsYXIgdmFs dWUsIHByb2R1Y2luZyBhbiBlcnJvciBpZiBpdAptdWx0aXBsZSB2YWx1ZXMgYXJlIG1hdGNoZWQu CgpCb3RoIEpTT05fVkFMVUUoKSBhbmQgSlNPTl9RVUVSWSgpIGZ1bmN0aW9ucyBoYXZlIG9wdGlv bnMgZm9yCmhhbmRsaW5nIEVNUFRZIGFuZCBFUlJPUiBjb25kaXRpb25zLCB3aGljaCBjYW4gYmUg dXNlZCB0byBzcGVjaWZ5CnRoZSBiZWhhdmlvciB3aGVuIG5vIHZhbHVlcyBhcmUgbWF0Y2hlZCBh bmQgd2hlbiBhbiBlcnJvciBvY2N1cnMKZHVyaW5nIGpzb25wYXRoIGV2YWx1YXRpb24sIHJlc3Bl Y3RpdmVseS4KCkF1dGhvcjogTmlraXRhIEdsdWtob3YgPG4uZ2x1aG92QHBvc3RncmVzcHJvLnJ1 PgpBdXRob3I6IFRlb2RvciBTaWdhZXYgPHRlb2RvckBzaWdhZXYucnU+CkF1dGhvcjogT2xlZyBC YXJ0dW5vdiA8b2JhcnR1bm92QGdtYWlsLmNvbT4KQXV0aG9yOiBBbGV4YW5kZXIgS29yb3Rrb3Yg PGFla29yb3Rrb3ZAZ21haWwuY29tPgpBdXRob3I6IEFuZHJldyBEdW5zdGFuIDxhbmRyZXdAZHVu c2xhbmUubmV0PgpBdXRob3I6IEFtaXQgTGFuZ290ZSA8YW1pdGxhbmdvdGUwOUBnbWFpbC5jb20+ CkF1dGhvcjogUGV0ZXIgRWlzZW50cmF1dCA8cGV0ZXJAZWlzZW50cmF1dC5vcmc+CkF1dGhvcjog SmlhbiBIZSA8amlhbi51bml2ZXJzYWxpdHlAZ21haWwuY29tPgoKUmV2aWV3ZXJzIGhhdmUgaW5j bHVkZWQgKGluIG5vIHBhcnRpY3VsYXIgb3JkZXIpOgoKQW5kcmVzIEZyZXVuZCwgQWxleGFuZGVy IEtvcm90a292LCBQYXZlbCBTdGVodWxlLCBBbmRyZXcgQWxzdXAsCkVyaWsgUmlqa2VycywgWmlo b25nIFl1LCBIaW1hbnNodSBVcGFkaHlheWEsIERhbmllbCBHdXN0YWZzc29uLApKdXN0aW4gUHJ5 emJ5LCDDgWx2YXJvIEhlcnJlcmEsIEppYW4gSGUsIEFudG9uIEEuIE1lbG5pa292LApOaWtpdGEg TWFsYWtob3YsIFBldGVyIEVpc2VudHJhdXQsIFRvbWFzIFZvbmRyYQoKRGlzY3Vzc2lvbjogaHR0 cHM6Ly9wb3N0Z3IuZXMvbS9jZDBiYjkzNS0wMTU4LTc4YTctMDhiNS05MDQ4ODZkZWFjNGJAcG9z dGdyZXNwcm8ucnUKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8yMDIyMDYxNjIzMzEz MC5ycGFyaXZhZmlwdDZkb2ozQGFsYXAzLmFuYXJhemVsLmRlCkRpc2N1c3Npb246IGh0dHBzOi8v cG9zdGdyLmVzL20vYWJkOWI4M2ItYWE2Ni1mMjMwLTNkNmQtNzM0ODE3ZjA5OTVkJTQwcG9zdGdy ZXNxbC5vcmcKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQStIaXdxSFJPcGY5ZTY0 NEQ4QlJxWXZhQVBtZ0JaVnVwLXhLTURQay1uZDRFcGd6SHdAbWFpbC5nbWFpbC5jb20KRGlzY3Vz c2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQStIaXdxRTRYVGRmYjFuVz1Pam95X3RRU1JoWXQt cV9rYjZpNWQ0eGNLeXJMQzFOYmdAbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVy CgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlm Zi82MTg1Yzk3MzdjZjQ4Yzk1NDA3ODJkODhmMTJiZDI5MTJkNmNhMWNjCgpNb2RpZmllZCBGaWxl cwotLS0tLS0tLS0tLS0tLQpkb2Mvc3JjL3NnbWwvZnVuYy5zZ21sICAgICAgICAgICAgICAgICAg ICAgICAgICAgfCAgMjEwICsrKysKc3JjL2JhY2tlbmQvY2F0YWxvZy9zcWxfZmVhdHVyZXMudHh0 ICAgICAgICAgICAgIHwgICAxMiArLQpzcmMvYmFja2VuZC9leGVjdXRvci9leGVjRXhwci5jICAg ICAgICAgICAgICAgICAgfCAgMzAxICsrKysrCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2V4ZWNFeHBy SW50ZXJwLmMgICAgICAgICAgICB8ICAzMzggKysrKystCnNyYy9iYWNrZW5kL2ppdC9sbHZtL2xs dm1qaXRfZXhwci5jICAgICAgICAgICAgICB8ICAxMDggKysKc3JjL2JhY2tlbmQvaml0L2xsdm0v bGx2bWppdF90eXBlcy5jICAgICAgICAgICAgIHwgICAgMyArCnNyYy9iYWNrZW5kL25vZGVzL21h a2VmdW5jcy5jICAgICAgICAgICAgICAgICAgICB8ICAgMTYgKwpzcmMvYmFja2VuZC9ub2Rlcy9u b2RlRnVuY3MuYyAgICAgICAgICAgICAgICAgICAgfCAgMTU5ICsrKwpzcmMvYmFja2VuZC9vcHRp bWl6ZXIvcGF0aC9jb3N0c2l6ZS5jICAgICAgICAgICAgfCAgICAzICstCnNyYy9iYWNrZW5kL29w dGltaXplci91dGlsL2NsYXVzZXMuYyAgICAgICAgICAgICB8ICAgMjAgKwpzcmMvYmFja2VuZC9w YXJzZXIvZ3JhbS55ICAgICAgICAgICAgICAgICAgICAgICAgfCAgMTg4ICsrKy0Kc3JjL2JhY2tl bmQvcGFyc2VyL3BhcnNlX2V4cHIuYyAgICAgICAgICAgICAgICAgIHwgIDU1MyArKysrKysrKyst CnNyYy9iYWNrZW5kL3BhcnNlci9wYXJzZV90YXJnZXQuYyAgICAgICAgICAgICAgICB8ICAgMTgg KwpzcmMvYmFja2VuZC91dGlscy9hZHQvZm9ybWF0dGluZy5jICAgICAgICAgICAgICAgfCAgIDQ0 ICsKc3JjL2JhY2tlbmQvdXRpbHMvYWR0L2pzb25iLmMgICAgICAgICAgICAgICAgICAgIHwgICAz MSArCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9qc29uZnVuY3MuYyAgICAgICAgICAgICAgICB8ICAg NjIgKy0Kc3JjL2JhY2tlbmQvdXRpbHMvYWR0L2pzb25wYXRoLmMgICAgICAgICAgICAgICAgIHwg IDI4MSArKysrKwpzcmMvYmFja2VuZC91dGlscy9hZHQvanNvbnBhdGhfZXhlYy5jICAgICAgICAg ICAgfCAgMzIyICsrKysrKwpzcmMvYmFja2VuZC91dGlscy9hZHQvcnVsZXV0aWxzLmMgICAgICAg ICAgICAgICAgfCAgMTM4ICsrKwpzcmMvaW5jbHVkZS9leGVjdXRvci9leGVjRXhwci5oICAgICAg ICAgICAgICAgICAgfCAgIDIyICsKc3JjL2luY2x1ZGUvbm9kZXMvZXhlY25vZGVzLmggICAgICAg ICAgICAgICAgICAgIHwgICA3MyArKwpzcmMvaW5jbHVkZS9ub2Rlcy9tYWtlZnVuY3MuaCAgICAg ICAgICAgICAgICAgICAgfCAgICAyICsKc3JjL2luY2x1ZGUvbm9kZXMvcGFyc2Vub2Rlcy5oICAg ICAgICAgICAgICAgICAgIHwgICA0MiArCnNyYy9pbmNsdWRlL25vZGVzL3ByaW1ub2Rlcy5oICAg ICAgICAgICAgICAgICAgICB8ICAxMjIgKysrCnNyYy9pbmNsdWRlL3BhcnNlci9rd2xpc3QuaCAg ICAgICAgICAgICAgICAgICAgICB8ICAgMTEgKwpzcmMvaW5jbHVkZS91dGlscy9mb3JtYXR0aW5n LmggICAgICAgICAgICAgICAgICAgfCAgICAxICsKc3JjL2luY2x1ZGUvdXRpbHMvanNvbmIuaCAg ICAgICAgICAgICAgICAgICAgICAgIHwgICAgMSArCnNyYy9pbmNsdWRlL3V0aWxzL2pzb25mdW5j cy5oICAgICAgICAgICAgICAgICAgICB8ICAgIDcgKwpzcmMvaW5jbHVkZS91dGlscy9qc29ucGF0 aC5oICAgICAgICAgICAgICAgICAgICAgfCAgIDI0ICsKc3JjL2ludGVyZmFjZXMvZWNwZy9wcmVw cm9jL2VjcGcudHJhaWxlciAgICAgICAgIHwgICAyOCArCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0 ZWQvc3FsanNvbl9xdWVyeWZ1bmNzLm91dCB8IDEyNjkgKysrKysrKysrKysrKysrKysrKysrKwpz cmMvdGVzdC9yZWdyZXNzL3BhcmFsbGVsX3NjaGVkdWxlICAgICAgICAgICAgICAgfCAgICAyICst CnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3NxbGpzb25fcXVlcnlmdW5jcy5zcWwgICAgICB8ICA0Mjgg KysrKysrKysKc3JjL3Rvb2xzL3BnaW5kZW50L3R5cGVkZWZzLmxpc3QgICAgICAgICAgICAgICAg IHwgICAxMiArCjM0IGZpbGVzIGNoYW5nZWQsIDQ4MTUgaW5zZXJ0aW9ucygrKSwgMzYgZGVsZXRp b25zKC0pCgo= --===============8496062448317871177==--