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 1nYa76-0000ka-BX for pgsql-committers@arkaria.postgresql.org; Sun, 27 Mar 2022 21:07:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nYa75-0005bC-6U for pgsql-committers@arkaria.postgresql.org; Sun, 27 Mar 2022 21:07:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nYa74-0005Yd-V3 for pgsql-committers@lists.postgresql.org; Sun, 27 Mar 2022 21:07:50 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nYa72-0002PH-0T for pgsql-committers@lists.postgresql.org; Sun, 27 Mar 2022 21:07: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 1nYa71-0001qU-IH for pgsql-committers@lists.postgresql.org; Sun, 27 Mar 2022 21:07:47 +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 1nYa6z-001ewL-T0 for pgsql-committers@lists.postgresql.org; Sun, 27 Mar 2022 21:07:46 +0000 Content-Type: multipart/mixed; boundary="===============6106342431250757940==" 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: Sun, 27 Mar 2022 21:07:46 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6106342431250757940== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Q29tbW9uIFNRTC9KU09OIGNsYXVzZXMKClRoaXMgaW50cm9kdWNlcyBzb21lIG9mIHRoZSBidWls ZGluZyBibG9ja3MgdXNlZCBieSB0aGUgU1FML0pTT04KY29uc3RydWN0b3IgYW5kIHF1ZXJ5IGZ1 bmN0aW9ucy4gU3BlY2lmaWNhbGx5LCBpdCBwcm92aWRlcyBub2RlCmV4ZWN1dG9yIGFuZCBncmFt bWFyIHN1cHBvcnQgZm9yIHRoZSBGT1JNQVQgSlNPTiBbRU5DT0RJTkcgZm9vXQpjbGF1c2UsIGFu ZCB2YWx1ZXMgZGVjb3JhdGVkIHdpdGggaXQsIGFuZCBmb3IgdGhlIFJFVFVSTklORyBjbGF1c2Uu CgpUaGUgZm9sbG93aW5nIFNRTC9KU09OIHBhdGNoZXMgd2lsbCBsZXZlcmFnZSB0aGVzZS4KCk5p a2l0YSBHbHVraG92ICh3aG8gcHJvYmFibHkgZGVzZXJ2ZXMgYW4gYXdhcmQgZm9yIHBlcnNldmVy YW5jZSkuCgpSZXZpZXdlcnMgaGF2ZSBpbmNsdWRlZCAoaW4gbm8gcGFydGljdWxhciBvcmRlcikg QW5kcmVzIEZyZXVuZCwgQWxleGFuZGVyCktvcm90a292LCBQYXZlbCBTdGVodWxlLCBBbmRyZXcg QWxzdXAsIEVyaWsgUmlqa2VycywgWmlob25nIFl1LApIaW1hbnNodSBVcGFkaHlheWEsIERhbmll bCBHdXN0YWZzc29uLCBKdXN0aW4gUHJ5emJ5LgoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3Iu ZXMvbS9jZDBiYjkzNS0wMTU4LTc4YTctMDhiNS05MDQ4ODZkZWFjNGJAcG9zdGdyZXNwcm8ucnUK CkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdy ZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9mNzliODAzZGNjOThkNzA3NDUwZTE1OGRiMzYzOGRjNjdm ZjgzODBiCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9leGVjdXRv ci9leGVjRXhwci5jICAgICAgfCAgMjIgKysrKysKc3JjL2JhY2tlbmQvbm9kZXMvY29weWZ1bmNz LmMgICAgICAgIHwgIDU1ICsrKysrKysrKysrCnNyYy9iYWNrZW5kL25vZGVzL2VxdWFsZnVuY3Mu YyAgICAgICB8ICAzOSArKysrKysrKwpzcmMvYmFja2VuZC9ub2Rlcy9tYWtlZnVuY3MuYyAgICAg ICAgfCAgNTQgKysrKysrKysrKysKc3JjL2JhY2tlbmQvbm9kZXMvbm9kZUZ1bmNzLmMgICAgICAg IHwgIDY2ICsrKysrKysrKysrKysKc3JjL2JhY2tlbmQvbm9kZXMvb3V0ZnVuY3MuYyAgICAgICAg IHwgIDM5ICsrKysrKysrCnNyYy9iYWNrZW5kL25vZGVzL3JlYWRmdW5jcy5jICAgICAgICB8ICA1 MSArKysrKysrKysrCnNyYy9iYWNrZW5kL29wdGltaXplci91dGlsL2NsYXVzZXMuYyB8ICAyMyAr KysrKwpzcmMvYmFja2VuZC9wYXJzZXIvZ3JhbS55ICAgICAgICAgICAgfCAgNjUgKysrKysrKysr KysrLQpzcmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfZXhwci5jICAgICAgfCAxODEgKysrKysrKysr KysrKysrKysrKysrKysrKysrKysrKysrKysKc3JjL2JhY2tlbmQvdXRpbHMvYWR0L3J1bGV1dGls cy5jICAgIHwgIDU2ICsrKysrKysrKysrCnNyYy9iYWNrZW5kL3V0aWxzL21pc2MvcXVlcnlqdW1i bGUuYyB8ICAyNiArKysrKwpzcmMvaW5jbHVkZS9ub2Rlcy9tYWtlZnVuY3MuaCAgICAgICAgfCAg IDUgKwpzcmMvaW5jbHVkZS9ub2Rlcy9ub2Rlcy5oICAgICAgICAgICAgfCAgIDQgKwpzcmMvaW5j bHVkZS9ub2Rlcy9wYXJzZW5vZGVzLmggICAgICAgfCAgMTMgKysrCnNyYy9pbmNsdWRlL25vZGVz L3ByaW1ub2Rlcy5oICAgICAgICB8ICA1OSArKysrKysrKysrKysKc3JjL2luY2x1ZGUvcGFyc2Vy L2t3bGlzdC5oICAgICAgICAgIHwgICAyICsKMTcgZmlsZXMgY2hhbmdlZCwgNzU4IGluc2VydGlv bnMoKyksIDIgZGVsZXRpb25zKC0pCgo= --===============6106342431250757940==--