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 1rqVZQ-00Cnlw-Ff for pgsql-committers@arkaria.postgresql.org; Sat, 30 Mar 2024 10:04:16 +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 1rqVZP-007iui-BI for pgsql-committers@arkaria.postgresql.org; Sat, 30 Mar 2024 10:04:15 +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 1rqVZP-007iua-3v for pgsql-committers@lists.postgresql.org; Sat, 30 Mar 2024 10:04:15 +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 1rqVZK-007cAb-EZ for pgsql-committers@lists.postgresql.org; Sat, 30 Mar 2024 10:04:14 +0000 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 1rqVZI-002VqL-4F for pgsql-committers@lists.postgresql.org; Sat, 30 Mar 2024 10:04:08 +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 1rqVZH-006TRK-1p for pgsql-committers@lists.postgresql.org; Sat, 30 Mar 2024 10:04:07 +0000 Content-Type: multipart/mixed; boundary="===============3142052653649087600==" MIME-Version: 1.0 From: Dean Rasheed To: pgsql-committers@lists.postgresql.org Subject: pgsql: Add support for MERGE ... WHEN NOT MATCHED BY SOURCE. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 30 Mar 2024 10:04:07 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3142052653649087600== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRkIHN1cHBvcnQgZm9yIE1FUkdFIC4uLiBXSEVOIE5PVCBNQVRDSEVEIEJZIFNPVVJDRS4KClRo aXMgYWxsb3dzIE1FUkdFIGNvbW1hbmRzIHRvIGluY2x1ZGUgV0hFTiBOT1QgTUFUQ0hFRCBCWSBT T1VSQ0UKYWN0aW9ucywgd2hpY2ggb3BlcmF0ZSBvbiByb3dzIHRoYXQgZXhpc3QgaW4gdGhlIHRh cmdldCByZWxhdGlvbiwgYnV0Cm5vdCBpbiB0aGUgZGF0YSBzb3VyY2UuIFRoZXNlIGFjdGlvbnMg Y2FuIGV4ZWN1dGUgVVBEQVRFLCBERUxFVEUsIG9yCkRPIE5PVEhJTkcgc3ViLWNvbW1hbmRzLgoK VGhpcyBpcyBpbiBjb250cmFzdCB0byBhbHJlYWR5LXN1cHBvcnRlZCBXSEVOIE5PVCBNQVRDSEVE IGFjdGlvbnMsCndoaWNoIG9wZXJhdGUgb24gcm93cyB0aGF0IGV4aXN0IGluIHRoZSBkYXRhIHNv dXJjZSwgYnV0IG5vdCBpbiB0aGUKdGFyZ2V0IHJlbGF0aW9uLiBUbyBtYWtlIHRoaXMgZGlzdGlu Y3Rpb24gY2xlYXJlciwgc3VjaCBhY3Rpb25zIG1heQpub3cgYmUgd3JpdHRlbiBhcyBXSEVOIE5P VCBNQVRDSEVEIEJZIFRBUkdFVC4KCldyaXRpbmcgV0hFTiBOT1QgTUFUQ0hFRCB3aXRob3V0IHNw ZWNpZnlpbmcgQlkgU09VUkNFIG9yIEJZIFRBUkdFVCBpcwplcXVpdmFsZW50IHRvIHdyaXRpbmcg V0hFTiBOT1QgTUFUQ0hFRCBCWSBUQVJHRVQuCgpEZWFuIFJhc2hlZWQsIHJldmlld2VkIGJ5IEFs dmFybyBIZXJyZXJhLCBUZWQgWXUgYW5kIFZpayBGZWFyaW5nLgoKRGlzY3Vzc2lvbjogaHR0cHM6 Ly9wb3N0Z3IuZXMvbS9DQUVaQVRDV3FuS0djNTdZX0phblVCSFFYTktjWGQ3cj0wUjRORVpVVndQ K3N5UmtXYkFAbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0t LS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8wMjk0ZGYyZjFm ODQyZGZiMGVlZDc5MDA3YjIxMDE2ZjQ4NmEzYzZjCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0t LS0tLQpkb2Mvc3JjL3NnbWwvbXZjYy5zZ21sICAgICAgICAgICAgICAgICAgICAgICAgfCAgMTIg Ky0KZG9jL3NyYy9zZ21sL3JlZi9tZXJnZS5zZ21sICAgICAgICAgICAgICAgICAgIHwgMTAwICsr KysrLS0Kc3JjL2JhY2tlbmQvZXhlY3V0b3IvZXhlY01haW4uYyAgICAgICAgICAgICAgIHwgICA2 ICstCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2V4ZWNQYXJ0aXRpb24uYyAgICAgICAgICB8ICAyMSAr LQpzcmMvYmFja2VuZC9leGVjdXRvci9ub2RlTW9kaWZ5VGFibGUuYyAgICAgICAgfCAzODcgKysr KysrKysrKysrKysrKy0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvbm9kZXMvbm9kZUZ1bmNzLmMgICAg ICAgICAgICAgICAgIHwgICAzICsKc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vY3JlYXRlcGxh bi5jICAgICAgIHwgICA4ICstCnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL3BsYW5uZXIuYyAg ICAgICAgICB8ICAyMiArKwpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9zZXRyZWZzLmMgICAg ICAgICAgfCAgMjAgKy0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3ByZXAvcHJlcGpvaW50cmVlLmMg ICAgIHwgIDUxICsrKy0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3ByZXAvcHJlcHRsaXN0LmMgICAg ICAgIHwgIDI2ICstCnNyYy9iYWNrZW5kL29wdGltaXplci91dGlsL3BhdGhub2RlLmMgICAgICAg ICB8ICAgNSArLQpzcmMvYmFja2VuZC9wYXJzZXIvZ3JhbS55ICAgICAgICAgICAgICAgICAgICAg fCAgNjIgKysrLS0Kc3JjL2JhY2tlbmQvcGFyc2VyL3BhcnNlX21lcmdlLmMgICAgICAgICAgICAg IHwgIDU2ICsrLS0Kc3JjL2JhY2tlbmQvdXRpbHMvYWR0L3J1bGV1dGlscy5jICAgICAgICAgICAg IHwgIDQxICsrLQpzcmMvYmluL3BzcWwvdGFiLWNvbXBsZXRlLmMgICAgICAgICAgICAgICAgICAg fCAgMzAgKy0Kc3JjL2luY2x1ZGUvY2F0YWxvZy9jYXR2ZXJzaW9uLmggICAgICAgICAgICAgIHwg ICAyICstCnNyYy9pbmNsdWRlL25vZGVzL2V4ZWNub2Rlcy5oICAgICAgICAgICAgICAgICB8ICAx NSArLQpzcmMvaW5jbHVkZS9ub2Rlcy9wYXJzZW5vZGVzLmggICAgICAgICAgICAgICAgfCAgIDcg Ky0Kc3JjL2luY2x1ZGUvbm9kZXMvcGF0aG5vZGVzLmggICAgICAgICAgICAgICAgIHwgICAyICsK c3JjL2luY2x1ZGUvbm9kZXMvcGxhbm5vZGVzLmggICAgICAgICAgICAgICAgIHwgICAyICsKc3Jj L2luY2x1ZGUvbm9kZXMvcHJpbW5vZGVzLmggICAgICAgICAgICAgICAgIHwgIDEwICstCnNyYy9p bmNsdWRlL29wdGltaXplci9wYXRobm9kZS5oICAgICAgICAgICAgICB8ICAgMyArLQpzcmMvaW5j bHVkZS9wYXJzZXIva3dsaXN0LmggICAgICAgICAgICAgICAgICAgfCAgIDIgKwpzcmMvdGVzdC9p c29sYXRpb24vZXhwZWN0ZWQvbWVyZ2UtdXBkYXRlLm91dCAgfCAgODggKysrKy0tCnNyYy90ZXN0 L2lzb2xhdGlvbi9zcGVjcy9tZXJnZS11cGRhdGUuc3BlYyAgICB8ICAxMCArLQpzcmMvdGVzdC9y ZWdyZXNzL2V4cGVjdGVkL21lcmdlLm91dCAgICAgICAgICAgfCAyOTkgKysrKysrKysrKysrKysr LS0tLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9ydWxlcy5vdXQgICAgICAgICAgIHwgIDMy ICsrKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3VwZGF0YWJsZV92aWV3cy5vdXQgfCAgOTAg KysrKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL21lcmdlLnNxbCAgICAgICAgICAgICAgICB8IDEy MiArKysrKystLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC9ydWxlcy5zcWwgICAgICAgICAgICAgICAg fCAgMTkgKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvdXBkYXRhYmxlX3ZpZXdzLnNxbCAgICAgIHwg IDMyICsrKwpzcmMvdG9vbHMvcGdpbmRlbnQvdHlwZWRlZnMubGlzdCAgICAgICAgICAgICAgfCAg IDEgKwozMyBmaWxlcyBjaGFuZ2VkLCAxMjI2IGluc2VydGlvbnMoKyksIDM2MCBkZWxldGlvbnMo LSkKCg== --===============3142052653649087600==--