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 1rlr85-004ZiS-UD for pgsql-committers@arkaria.postgresql.org; Sun, 17 Mar 2024 14:04:50 +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 1rlr83-00B25E-NE for pgsql-committers@arkaria.postgresql.org; Sun, 17 Mar 2024 14:04:48 +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 1rlr83-00B256-Fy for pgsql-committers@lists.postgresql.org; Sun, 17 Mar 2024 14:04:47 +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 1rlr80-0051Yd-9r for pgsql-committers@lists.postgresql.org; Sun, 17 Mar 2024 14:04:47 +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 1rlr7x-00DUf7-FL for pgsql-committers@lists.postgresql.org; Sun, 17 Mar 2024 14:04:42 +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 1rlr7w-004I1h-Sg for pgsql-committers@lists.postgresql.org; Sun, 17 Mar 2024 14:04:41 +0000 Content-Type: multipart/mixed; boundary="===============3235898618501144502==" MIME-Version: 1.0 From: Dean Rasheed To: pgsql-committers@lists.postgresql.org Subject: pgsql: Add RETURNING support to MERGE. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sun, 17 Mar 2024 14:04:41 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3235898618501144502== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRkIFJFVFVSTklORyBzdXBwb3J0IHRvIE1FUkdFLgoKVGhpcyBhbGxvd3MgYSBSRVRVUk5JTkcg Y2xhdXNlIHRvIGJlIGFwcGVuZGVkIHRvIGEgTUVSR0UgcXVlcnksIHRvCnJldHVybiB2YWx1ZXMg YmFzZWQgb24gZWFjaCByb3cgaW5zZXJ0ZWQsIHVwZGF0ZWQsIG9yIGRlbGV0ZWQuIEFzIHdpdGgK cGxhaW4gSU5TRVJULCBVUERBVEUsIGFuZCBERUxFVEUgY29tbWFuZHMsIHRoZSByZXR1cm5lZCB2 YWx1ZXMgYXJlCmJhc2VkIG9uIHRoZSBuZXcgY29udGVudHMgb2YgdGhlIHRhcmdldCB0YWJsZSBm b3IgSU5TRVJUIGFuZCBVUERBVEUKYWN0aW9ucywgYW5kIG9uIGl0cyBvbGQgY29udGVudHMgZm9y IERFTEVURSBhY3Rpb25zLiBWYWx1ZXMgZnJvbSB0aGUKc291cmNlIHJlbGF0aW9uIG1heSBhbHNv IGJlIHJldHVybmVkLgoKQXMgd2l0aCBJTlNFUlQvVVBEQVRFL0RFTEVURSwgdGhlIG91dHB1dCBv ZiBNRVJHRSAuLi4gUkVUVVJOSU5HIG1heSBiZQp1c2VkIGFzIHRoZSBzb3VyY2UgcmVsYXRpb24g Zm9yIG90aGVyIG9wZXJhdGlvbnMgc3VjaCBhcyBXSVRIIHF1ZXJpZXMKYW5kIENPUFkgY29tbWFu ZHMuCgpBZGRpdGlvbmFsbHksIGEgc3BlY2lhbCBmdW5jdGlvbiBtZXJnZV9hY3Rpb24oKSBpcyBw cm92aWRlZCwgd2hpY2gKcmV0dXJucyAnSU5TRVJUJywgJ1VQREFURScsIG9yICdERUxFVEUnLCBk ZXBlbmRpbmcgb24gdGhlIGFjdGlvbgpleGVjdXRlZCBmb3IgZWFjaCByb3cuIFRoZSBtZXJnZV9h Y3Rpb24oKSBmdW5jdGlvbiBjYW4gYmUgdXNlZAphbnl3aGVyZSBpbiB0aGUgUkVUVVJOSU5HIGxp c3QsIGluY2x1ZGluZyBpbiBhcmJpdHJhcnkgZXhwcmVzc2lvbnMgYW5kCnN1YnF1ZXJpZXMsIGJ1 dCBpdCBpcyBhbiBlcnJvciB0byB1c2UgaXQgYW55d2hlcmUgb3V0c2lkZSBvZiBhIE1FUkdFCnF1 ZXJ5J3MgUkVUVVJOSU5HIGxpc3QuCgpEZWFuIFJhc2hlZWQsIHJldmlld2VkIGJ5IElzYWFjIE1v cmxhbmQsIFZpayBGZWFyaW5nLCBBbHZhcm8gSGVycmVyYSwKR3VyamVldCBTaW5naCwgSmlhbiBI ZSwgSmVmZiBEYXZpcywgTWVybGluIE1vbmN1cmUsIFBldGVyIEVpc2VudHJhdXQsCmFuZCBXb2xm Z2FuZyBXYWx0aGVyLgoKRGlzY3Vzc2lvbjogaHR0cDovL3Bvc3Rnci5lcy9tL0NBRVpBVENXZVBF R1FSNUxCbi12RDZTZmVMWmFmekVtMlF5X0xfT2t5Mj1xdzJ3M1B6Z0BtYWlsLmdtYWlsLmNvbQoK QnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jl c3FsLm9yZy9wZy9jb21taXRkaWZmL2M2NDlmYTI0YTQyYmE4OWJmNTQ2MGM3MTEwZTRmYzhlZWNh NjU5NTkKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9kbWwuc2dt bCAgICAgICAgICAgICAgICAgICAgICAgICB8ICAyMiArKy0KZG9jL3NyYy9zZ21sL2Z1bmMuc2dt bCAgICAgICAgICAgICAgICAgICAgICAgIHwgIDc5ICsrKysrKysrCmRvYy9zcmMvc2dtbC9nbG9z c2FyeS5zZ21sICAgICAgICAgICAgICAgICAgICB8ICAgNiArLQpkb2Mvc3JjL3NnbWwvcGxwZ3Nx bC5zZ21sICAgICAgICAgICAgICAgICAgICAgfCAgMTYgKy0KZG9jL3NyYy9zZ21sL3F1ZXJpZXMu c2dtbCAgICAgICAgICAgICAgICAgICAgIHwgICA5ICstCmRvYy9zcmMvc2dtbC9yZWYvY29weS5z Z21sICAgICAgICAgICAgICAgICAgICB8ICAxOSArLQpkb2Mvc3JjL3NnbWwvcmVmL21lcmdlLnNn bWwgICAgICAgICAgICAgICAgICAgfCAgNjggKysrKystLQpkb2Mvc3JjL3NnbWwvcmVmL3NlbGVj dC5zZ21sICAgICAgICAgICAgICAgICAgfCAgMTEgKy0KZG9jL3NyYy9zZ21sL3Jvd3R5cGVzLnNn bWwgICAgICAgICAgICAgICAgICAgIHwgICAyICstCmRvYy9zcmMvc2dtbC9zcGkuc2dtbCAgICAg ICAgICAgICAgICAgICAgICAgICB8ICAxNCArLQpkb2Mvc3JjL3NnbWwveGZ1bmMuc2dtbCAgICAg ICAgICAgICAgICAgICAgICAgfCAgIDggKy0Kc3JjL2JhY2tlbmQvY29tbWFuZHMvY29weS5jICAg ICAgICAgICAgICAgICAgIHwgICA2IC0Kc3JjL2JhY2tlbmQvY29tbWFuZHMvY29weXRvLmMgICAg ICAgICAgICAgICAgIHwgICAzICstCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2V4ZWNFeHByLmMgICAg ICAgICAgICAgICB8ICAxMyArKwpzcmMvYmFja2VuZC9leGVjdXRvci9leGVjRXhwckludGVycC5j ICAgICAgICAgfCAgNDggKysrKysKc3JjL2JhY2tlbmQvZXhlY3V0b3IvZXhlY1BhcnRpdGlvbi5j ICAgICAgICAgIHwgICA4ICstCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2Z1bmN0aW9ucy5jICAgICAg ICAgICAgICB8ICAgOSArLQpzcmMvYmFja2VuZC9leGVjdXRvci9ub2RlTW9kaWZ5VGFibGUuYyAg ICAgICAgfCAyMDIgKysrKysrKysrKysrKy0tLS0tLQpzcmMvYmFja2VuZC9leGVjdXRvci9zcGku YyAgICAgICAgICAgICAgICAgICAgfCAgIDcgKy0Kc3JjL2JhY2tlbmQvaml0L2xsdm0vbGx2bWpp dF9leHByLmMgICAgICAgICAgIHwgICA2ICsKc3JjL2JhY2tlbmQvaml0L2xsdm0vbGx2bWppdF90 eXBlcy5jICAgICAgICAgIHwgICAxICsKc3JjL2JhY2tlbmQvbm9kZXMvbm9kZUZ1bmNzLmMgICAg ICAgICAgICAgICAgIHwgIDE3ICsrCnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL3N1YnNlbGVj dC5jICAgICAgICB8ICAgOSArLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvdXRpbC9wYXJhbWFzc2ln bi5jICAgICAgfCAgNTEgKysrKysKc3JjL2JhY2tlbmQvcGFyc2VyL2FuYWx5emUuYyAgICAgICAg ICAgICAgICAgIHwgIDE5ICstCnNyYy9iYWNrZW5kL3BhcnNlci9ncmFtLnkgICAgICAgICAgICAg ICAgICAgICB8ICAxNCArLQpzcmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfYWdnLmMgICAgICAgICAg ICAgICAgfCAgIDIgKwpzcmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfY3RlLmMgICAgICAgICAgICAg ICAgfCAgMTAgKy0Kc3JjL2JhY2tlbmQvcGFyc2VyL3BhcnNlX2V4cHIuYyAgICAgICAgICAgICAg IHwgIDM0ICsrKysKc3JjL2JhY2tlbmQvcGFyc2VyL3BhcnNlX2Z1bmMuYyAgICAgICAgICAgICAg IHwgICAxICsKc3JjL2JhY2tlbmQvcGFyc2VyL3BhcnNlX21lcmdlLmMgICAgICAgICAgICAgIHwg ICA3ICstCnNyYy9iYWNrZW5kL3BhcnNlci9wYXJzZV9yZWxhdGlvbi5jICAgICAgICAgICB8ICAg NyArLQpzcmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfdGFyZ2V0LmMgICAgICAgICAgICAgfCAgIDQg KwpzcmMvYmFja2VuZC9yZXdyaXRlL3Jld3JpdGVIYW5kbGVyLmMgICAgICAgICAgfCAgIDkgKy0K c3JjL2JhY2tlbmQvcmV3cml0ZS9yb3dzZWN1cml0eS5jICAgICAgICAgICAgIHwgIDI4ICsrLQpz cmMvYmFja2VuZC90Y29wL3V0aWxpdHkuYyAgICAgICAgICAgICAgICAgICAgfCAgIDMgKy0Kc3Jj L2JhY2tlbmQvdXRpbHMvYWR0L3J1bGV1dGlscy5jICAgICAgICAgICAgIHwgIDE0ICstCnNyYy9i aW4vcHNxbC9jb21tb24uYyAgICAgICAgICAgICAgICAgICAgICAgICB8ICAgOCArLQpzcmMvaW5j bHVkZS9jYXRhbG9nL2NhdHZlcnNpb24uaCAgICAgICAgICAgICAgfCAgIDIgKy0Kc3JjL2luY2x1 ZGUvZXhlY3V0b3IvZXhlY0V4cHIuaCAgICAgICAgICAgICAgIHwgICAzICsKc3JjL2luY2x1ZGUv ZXhlY3V0b3Ivc3BpLmggICAgICAgICAgICAgICAgICAgIHwgICAxICsKc3JjL2luY2x1ZGUvbm9k ZXMvZXhlY25vZGVzLmggICAgICAgICAgICAgICAgIHwgICAzICsKc3JjL2luY2x1ZGUvbm9kZXMv cGFyc2Vub2Rlcy5oICAgICAgICAgICAgICAgIHwgICAxICsKc3JjL2luY2x1ZGUvbm9kZXMvcHJp bW5vZGVzLmggICAgICAgICAgICAgICAgIHwgIDIxICsrCnNyYy9pbmNsdWRlL29wdGltaXplci9w YXJhbWFzc2lnbi5oICAgICAgICAgICB8ICAgMiArCnNyYy9pbmNsdWRlL3BhcnNlci9hbmFseXpl LmggICAgICAgICAgICAgICAgICB8ICAgMiArCnNyYy9pbmNsdWRlL3BhcnNlci9rd2xpc3QuaCAg ICAgICAgICAgICAgICAgICB8ICAgMSArCnNyYy9pbmNsdWRlL3BhcnNlci9wYXJzZV9ub2RlLmgg ICAgICAgICAgICAgICB8ICAgMyArLQpzcmMvcGwvcGxwZ3NxbC9zcmMvcGxfZXhlYy5jICAgICAg ICAgICAgICAgICAgfCAgMTIgKy0Kc3JjL3BsL3RjbC9wbHRjbC5jICAgICAgICAgICAgICAgICAg ICAgICAgICAgIHwgICAxICsKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9tZXJnZS5vdXQgICAg ICAgICAgIHwgMjY2ICsrKysrKysrKysrKysrKysrKysrKysrKy0tCnNyYy90ZXN0L3JlZ3Jlc3Mv ZXhwZWN0ZWQvcm93c2VjdXJpdHkub3V0ICAgICB8ICAzMiArKystCnNyYy90ZXN0L3JlZ3Jlc3Mv ZXhwZWN0ZWQvcnVsZXMub3V0ICAgICAgICAgICB8ICAxNiArLQpzcmMvdGVzdC9yZWdyZXNzL2V4 cGVjdGVkL3VwZGF0YWJsZV92aWV3cy5vdXQgfCAgMzAgKystCnNyYy90ZXN0L3JlZ3Jlc3MvZXhw ZWN0ZWQvd2l0aC5vdXQgICAgICAgICAgICB8ICAxMCArCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL21l cmdlLnNxbCAgICAgICAgICAgICAgICB8IDE2OSArKysrKysrKysrKysrKy0tCnNyYy90ZXN0L3Jl Z3Jlc3Mvc3FsL3Jvd3NlY3VyaXR5LnNxbCAgICAgICAgICB8ICAyMSArKwpzcmMvdGVzdC9yZWdy ZXNzL3NxbC9ydWxlcy5zcWwgICAgICAgICAgICAgICAgfCAgIDYgKy0Kc3JjL3Rlc3QvcmVncmVz cy9zcWwvdXBkYXRhYmxlX3ZpZXdzLnNxbCAgICAgIHwgICA5ICstCnNyYy90ZXN0L3JlZ3Jlc3Mv c3FsL3dpdGguc3FsICAgICAgICAgICAgICAgICB8ICAgOCArCnNyYy90b29scy9wZ2luZGVudC90 eXBlZGVmcy5saXN0ICAgICAgICAgICAgICB8ICAgMSArCjYxIGZpbGVzIGNoYW5nZWQsIDExOTgg aW5zZXJ0aW9ucygrKSwgMjE2IGRlbGV0aW9ucygtKQoK --===============3235898618501144502==--