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 1nWm9C-0001KU-0V for pgsql-committers@arkaria.postgresql.org; Tue, 22 Mar 2022 21:34:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nWm99-0003WE-F6 for pgsql-committers@arkaria.postgresql.org; Tue, 22 Mar 2022 21:34:31 +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 1nWm99-0003W5-87 for pgsql-committers@lists.postgresql.org; Tue, 22 Mar 2022 21:34:31 +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 1nWm96-0000Hm-KR for pgsql-committers@lists.postgresql.org; Tue, 22 Mar 2022 21:34:30 +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 1nWm94-0000l3-9s for pgsql-committers@lists.postgresql.org; Tue, 22 Mar 2022 21:34:26 +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 1nWm92-000vEf-FT for pgsql-committers@lists.postgresql.org; Tue, 22 Mar 2022 21:34:25 +0000 Content-Type: multipart/mixed; boundary="===============6334082615511672379==" MIME-Version: 1.0 From: Andrew Dunstan To: pgsql-committers@lists.postgresql.org Subject: pgsql: Common SQL/JSON clauses X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 22 Mar 2022 21:34:25 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6334082615511672379== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Q29tbW9uIFNRTC9KU09OIGNsYXVzZXMKClRoaXMgaW50cm9kdWNlcyBzb21lIG9mIHRoZSBidWls ZGluZyBibG9ja3MgdXNlZCBieSB0aGUgU1FML0pTT04KY29uc3RydWN0b3IgYW5kIHF1ZXJ5IGZ1 bmN0aW9ucy4gU3BlY2lmaWNhbGx5LCBpdCBwcm92aWRlcyBub2RlCmV4ZWN1dG9yIGFuZCBncmFt bWFyIHN1cHBvcnQgZm9yIHRoZSBGT1JNQVQgSlNPTiBbRU5DT0RJTkcgZm9vXQpjbGF1c2UsIGFu ZCB2YWx1ZXMgZGVjb3JhdGVkIHdpdGggaXQsIGFuZCBmb3IgdGhlIFJFVFVSTklORyBjbGF1c2Uu CgpUaGUgZm9sbG93aW5nIFNRTC9KU09OIHBhdGNoZXMgd2lsbCBsZXZlcmFnZSB0aGVzZS4KCk5p a2l0YSBHbHVraG92ICh3aG8gcHJvYmFibHkgZGVzZXJ2ZXMgYW4gYXdhcmQgZm9yIHBlcnNldmVy YW5jZSkuCgpSZXZpZXdlcnMgaGF2ZSBpbmNsdWRlZCAoaW4gbm8gcGFydGljdWxhciBvcmRlcikg QW5kcmVzIEZyZXVuZCwgQWxleGFuZGVyCktvcm90a292LCBQYXZlbCBTdGVodWxlLCBBbmRyZXcg QWxzdXAuIEVyaWsgUmlqa2VycywgWmlob25nIFl1IGFuZApIaW1hbnNodSBVcGFkaHlheWEuCgpE aXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL2NkMGJiOTM1LTAxNTgtNzhhNy0wOGI1LTkw NDg4NmRlYWM0YkBwb3N0Z3Jlc3Byby5ydQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMK LS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzg2NWZlNGQ1 ZGY1NjBhNmY1MzUzZGE2NTIwMThmZjg3Njk3OGFkMmQKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0t LS0tLS0tCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2V4ZWNFeHByLmMgICAgICB8ICAyMiArKysrKwpz cmMvYmFja2VuZC9ub2Rlcy9jb3B5ZnVuY3MuYyAgICAgICAgfCAgNTUgKysrKysrKysrKysKc3Jj L2JhY2tlbmQvbm9kZXMvZXF1YWxmdW5jcy5jICAgICAgIHwgIDM5ICsrKysrKysrCnNyYy9iYWNr ZW5kL25vZGVzL21ha2VmdW5jcy5jICAgICAgICB8ICA1NCArKysrKysrKysrKwpzcmMvYmFja2Vu ZC9ub2Rlcy9ub2RlRnVuY3MuYyAgICAgICAgfCAgNjYgKysrKysrKysrKysrKwpzcmMvYmFja2Vu ZC9ub2Rlcy9vdXRmdW5jcy5jICAgICAgICAgfCAgMzkgKysrKysrKysKc3JjL2JhY2tlbmQvbm9k ZXMvcmVhZGZ1bmNzLmMgICAgICAgIHwgIDUxICsrKysrKysrKysKc3JjL2JhY2tlbmQvb3B0aW1p emVyL3V0aWwvY2xhdXNlcy5jIHwgIDIzICsrKysrCnNyYy9iYWNrZW5kL3BhcnNlci9ncmFtLnkg ICAgICAgICAgICB8ICA2NSArKysrKysrKysrKystCnNyYy9iYWNrZW5kL3BhcnNlci9wYXJzZV9l eHByLmMgICAgICB8IDE4MSArKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKwpzcmMv YmFja2VuZC91dGlscy9hZHQvcnVsZXV0aWxzLmMgICAgfCAgNTYgKysrKysrKysrKysKc3JjL2Jh Y2tlbmQvdXRpbHMvbWlzYy9xdWVyeWp1bWJsZS5jIHwgIDI2ICsrKysrCnNyYy9pbmNsdWRlL25v ZGVzL21ha2VmdW5jcy5oICAgICAgICB8ICAgNSArCnNyYy9pbmNsdWRlL25vZGVzL25vZGVzLmgg ICAgICAgICAgICB8ICAgNCArCnNyYy9pbmNsdWRlL25vZGVzL3BhcnNlbm9kZXMuaCAgICAgICB8 ICAxMyArKysKc3JjL2luY2x1ZGUvbm9kZXMvcHJpbW5vZGVzLmggICAgICAgIHwgIDU5ICsrKysr KysrKysrKwpzcmMvaW5jbHVkZS9wYXJzZXIva3dsaXN0LmggICAgICAgICAgfCAgIDIgKwoxNyBm aWxlcyBjaGFuZ2VkLCA3NTggaW5zZXJ0aW9ucygrKSwgMiBkZWxldGlvbnMoLSkKCg== --===============6334082615511672379==--