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 1tYRLL-00ArKo-Fs for pgsql-committers@arkaria.postgresql.org; Thu, 16 Jan 2025 14:59:36 +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 1tYRLK-00EMKp-6N for pgsql-committers@arkaria.postgresql.org; Thu, 16 Jan 2025 14:59:34 +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 1tYRLJ-00EMKh-UO for pgsql-committers@lists.postgresql.org; Thu, 16 Jan 2025 14:59:34 +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.96) (envelope-from ) id 1tYRLH-000m8s-2m for pgsql-committers@lists.postgresql.org; Thu, 16 Jan 2025 14:59:34 +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 1tYRLE-005lOr-NT for pgsql-committers@lists.postgresql.org; Thu, 16 Jan 2025 14:59:28 +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 1tYRLD-001vzY-Qi for pgsql-committers@lists.postgresql.org; Thu, 16 Jan 2025 14:59:28 +0000 Content-Type: multipart/mixed; boundary="===============8021987912589445126==" MIME-Version: 1.0 From: Dean Rasheed To: pgsql-committers@lists.postgresql.org Subject: pgsql: Add OLD/NEW support to RETURNING in DML queries. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 16 Jan 2025 14:59:28 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8021987912589445126== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRkIE9MRC9ORVcgc3VwcG9ydCB0byBSRVRVUk5JTkcgaW4gRE1MIHF1ZXJpZXMuCgpUaGlzIGFs bG93cyB0aGUgUkVUVVJOSU5HIGxpc3Qgb2YgSU5TRVJUL1VQREFURS9ERUxFVEUvTUVSR0UgcXVl cmllcwp0byBleHBsaWNpdGx5IHJldHVybiBvbGQgYW5kIG5ldyB2YWx1ZXMgYnkgdXNpbmcgdGhl IHNwZWNpYWwgYWxpYXNlcwoib2xkIiBhbmQgIm5ldyIsIHdoaWNoIGFyZSBhdXRvbWF0aWNhbGx5 IGFkZGVkIHRvIHRoZSBxdWVyeSAoaWYgbm90CmFscmVhZHkgZGVmaW5lZCkgd2hpbGUgcGFyc2lu ZyBpdHMgUkVUVVJOSU5HIGxpc3QsIGFsbG93aW5nIHRoaW5ncwpsaWtlOgoKICBSRVRVUk5JTkcg b2xkLmNvbG5hbWUsIG5ldy5jb2xuYW1lLCAuLi4KCiAgUkVUVVJOSU5HIG9sZC4qLCBuZXcuKgoK QWRkaXRpb25hbGx5LCBhIG5ldyBzeW50YXggaXMgc3VwcG9ydGVkLCBhbGxvd2luZyB0aGUgbmFt ZXMgIm9sZCIgYW5kCiJuZXciIHRvIGJlIGNoYW5nZWQgdG8gdXNlci1zdXBwbGllZCBhbGlhcyBu YW1lcywgZS5nLjoKCiAgUkVUVVJOSU5HIFdJVEggKE9MRCBBUyBvLCBORVcgQVMgbikgby5jb2xu YW1lLCBuLmNvbG5hbWUsIC4uLgoKVGhpcyBpcyB1c2VmdWwgd2hlbiB0aGUgbmFtZXMgIm9sZCIg YW5kICJuZXciIGFyZSBhbHJlYWR5IGRlZmluZWQsCnN1Y2ggYXMgaW5zaWRlIHRyaWdnZXIgZnVu Y3Rpb25zLCBhbGxvd2luZyBiYWNrd2FyZHMgY29tcGF0aWJpbGl0eSB0bwpiZSBtYWludGFpbmVk IC0tIHRoZSBpbnRlcnByZXRhdGlvbiBvZiBhbnkgZXhpc3RpbmcgcXVlcmllcyB0aGF0CmhhcHBl biB0byBhbHJlYWR5IHJlZmVyIHRvIHJlbGF0aW9ucyBjYWxsZWQgIm9sZCIgb3IgIm5ldyIsIG9y IHVzZQp0aG9zZSBhcyBhbGlhc2VzIGZvciBvdGhlciByZWxhdGlvbnMsIGlzIG5vdCBjaGFuZ2Vk LgoKRm9yIGFuIElOU0VSVCwgb2xkIHZhbHVlcyB3aWxsIGdlbmVyYWxseSBiZSBOVUxMLCBhbmQg Zm9yIGEgREVMRVRFLApuZXcgdmFsdWVzIHdpbGwgZ2VuZXJhbGx5IGJlIE5VTEwsIGJ1dCB0aGF0 IG1heSBjaGFuZ2UgZm9yIGFuIElOU0VSVAp3aXRoIGFuIE9OIENPTkZMSUNUIC4uLiBETyBVUERB VEUgY2xhdXNlLCBvciBpZiBhIHF1ZXJ5IHJld3JpdGUgcnVsZQpjaGFuZ2VzIHRoZSBjb21tYW5k IHR5cGUuIFRoZXJlZm9yZSwgd2UgcHV0IG5vIHJlc3RyaWN0aW9ucyBvbiB0aGUgdXNlCm9mIG9s ZCBhbmQgbmV3IGluIGFueSBETUwgcXVlcmllcy4KCkRlYW4gUmFzaGVlZCwgcmV2aWV3ZWQgYnkg SmlhbiBIZSBhbmQgSmVmZiBEYXZpcy4KCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20v Q0FFWkFUQ1d4MEowLXY9UWpjNmdYelI9S3RzZHZBRTdPdz1EPW11NTBBZ09lK3B2aXNRQG1haWwu Z21haWwuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8v Z2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvODBmZWI3MjdjODY5Y2MwYjJlMTJiZDE1 NDNiYWZhNDQ5YmU5YzhlMgoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KY29udHJpYi9w b3N0Z3Jlc19mZHcvZXhwZWN0ZWQvcG9zdGdyZXNfZmR3Lm91dCB8IDEyNCArKysrKy0KY29udHJp Yi9wb3N0Z3Jlc19mZHcvc3FsL3Bvc3RncmVzX2Zkdy5zcWwgICAgICB8ICAyNSArLQpkb2Mvc3Jj L3NnbWwvZG1sLnNnbWwgICAgICAgICAgICAgICAgICAgICAgICAgIHwgIDQxICstCmRvYy9zcmMv c2dtbC9yZWYvZGVsZXRlLnNnbWwgICAgICAgICAgICAgICAgICAgfCAgNDAgKy0KZG9jL3NyYy9z Z21sL3JlZi9pbnNlcnQuc2dtbCAgICAgICAgICAgICAgICAgICB8ICA1NCArKy0KZG9jL3NyYy9z Z21sL3JlZi9tZXJnZS5zZ21sICAgICAgICAgICAgICAgICAgICB8ICAzNSArLQpkb2Mvc3JjL3Nn bWwvcmVmL3VwZGF0ZS5zZ21sICAgICAgICAgICAgICAgICAgIHwgIDM4ICstCmRvYy9zcmMvc2dt bC9ydWxlcy5zZ21sICAgICAgICAgICAgICAgICAgICAgICAgfCAgMTcgKwpzcmMvYmFja2VuZC9l eGVjdXRvci9leGVjRXhwci5jICAgICAgICAgICAgICAgIHwgMTU1ICsrKysrKy0Kc3JjL2JhY2tl bmQvZXhlY3V0b3IvZXhlY0V4cHJJbnRlcnAuYyAgICAgICAgICB8IDE4OSArKysrKysrKy0Kc3Jj L2JhY2tlbmQvZXhlY3V0b3IvZXhlY01haW4uYyAgICAgICAgICAgICAgICB8ICAgMSArCnNyYy9i YWNrZW5kL2V4ZWN1dG9yL2V4ZWNVdGlscy5jICAgICAgICAgICAgICAgfCAgMjggKysKc3JjL2Jh Y2tlbmQvZXhlY3V0b3Ivbm9kZU1vZGlmeVRhYmxlLmMgICAgICAgICB8IDIyMyArKysrKysrKy0t CnNyYy9iYWNrZW5kL2ppdC9sbHZtL2xsdm1qaXRfZXhwci5jICAgICAgICAgICAgfCAxMTkgKysr KystCnNyYy9iYWNrZW5kL25vZGVzL21ha2VmdW5jcy5jICAgICAgICAgICAgICAgICAgfCAgMTIg Ky0Kc3JjL2JhY2tlbmQvbm9kZXMvbm9kZUZ1bmNzLmMgICAgICAgICAgICAgICAgICB8ICA0NCAr LQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9hbGxwYXRocy5jICAgICAgICAgIHwgICAxICsK c3JjL2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vY3JlYXRlcGxhbi5jICAgICAgICB8ICAyMCArLQpz cmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9zZXRyZWZzLmMgICAgICAgICAgIHwgIDE1ICsKc3Jj L2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vc3Vic2VsZWN0LmMgICAgICAgICB8ICA0NSArLQpzcmMv YmFja2VuZC9vcHRpbWl6ZXIvcHJlcC9wcmVwam9pbnRyZWUuYyAgICAgIHwgICAzICstCnNyYy9i YWNrZW5kL29wdGltaXplci91dGlsL2FwcGVuZGluZm8uYyAgICAgICAgfCAgMjEgKy0Kc3JjL2Jh Y2tlbmQvb3B0aW1pemVyL3V0aWwvY2xhdXNlcy5jICAgICAgICAgICB8ICAgMyArCnNyYy9iYWNr ZW5kL29wdGltaXplci91dGlsL3BhcmFtYXNzaWduLmMgICAgICAgfCAgNDcgKysrCnNyYy9iYWNr ZW5kL29wdGltaXplci91dGlsL3BsYW5jYXQuYyAgICAgICAgICAgfCAgIDQgKy0Kc3JjL2JhY2tl bmQvb3B0aW1pemVyL3V0aWwvdmFyLmMgICAgICAgICAgICAgICB8ICA0NCArKwpzcmMvYmFja2Vu ZC9wYXJzZXIvYW5hbHl6ZS5jICAgICAgICAgICAgICAgICAgIHwgMTUwICsrKysrLS0Kc3JjL2Jh Y2tlbmQvcGFyc2VyL2dyYW0ueSAgICAgICAgICAgICAgICAgICAgICB8ICA1NyArKy0Kc3JjL2Jh Y2tlbmQvcGFyc2VyL3BhcnNlX2NsYXVzZS5jICAgICAgICAgICAgICB8ICAgMiArCnNyYy9iYWNr ZW5kL3BhcnNlci9wYXJzZV9leHByLmMgICAgICAgICAgICAgICAgfCAgMTggKy0Kc3JjL2JhY2tl bmQvcGFyc2VyL3BhcnNlX21lcmdlLmMgICAgICAgICAgICAgICB8ICAgNCArLQpzcmMvYmFja2Vu ZC9wYXJzZXIvcGFyc2VfcmVsYXRpb24uYyAgICAgICAgICAgIHwgIDMzICstCnNyYy9iYWNrZW5k L3BhcnNlci9wYXJzZV90YXJnZXQuYyAgICAgICAgICAgICAgfCAgIDQgKy0Kc3JjL2JhY2tlbmQv cmV3cml0ZS9yZXdyaXRlSGFuZGxlci5jICAgICAgICAgICB8ICAgOSArCnNyYy9iYWNrZW5kL3Jl d3JpdGUvcmV3cml0ZU1hbmlwLmMgICAgICAgICAgICAgfCAxMjggKysrKystCnNyYy9iYWNrZW5k L3V0aWxzL2FkdC9ydWxldXRpbHMuYyAgICAgICAgICAgICAgfCAxMTMgKysrLS0Kc3JjL2luY2x1 ZGUvY2F0YWxvZy9jYXR2ZXJzaW9uLmggICAgICAgICAgICAgICB8ICAgMiArLQpzcmMvaW5jbHVk ZS9leGVjdXRvci9leGVjRXhwci5oICAgICAgICAgICAgICAgIHwgIDI1ICstCnNyYy9pbmNsdWRl L2V4ZWN1dG9yL2V4ZWN1dG9yLmggICAgICAgICAgICAgICAgfCAgIDEgKwpzcmMvaW5jbHVkZS9u b2Rlcy9leGVjbm9kZXMuaCAgICAgICAgICAgICAgICAgIHwgIDE2ICsKc3JjL2luY2x1ZGUvbm9k ZXMvcGFyc2Vub2Rlcy5oICAgICAgICAgICAgICAgICB8ICA1MiArKy0Kc3JjL2luY2x1ZGUvbm9k ZXMvcGxhbm5vZGVzLmggICAgICAgICAgICAgICAgICB8ICAgMiArCnNyYy9pbmNsdWRlL25vZGVz L3ByaW1ub2Rlcy5oICAgICAgICAgICAgICAgICAgfCAgNDAgKysKc3JjL2luY2x1ZGUvb3B0aW1p emVyL29wdGltaXplci5oICAgICAgICAgICAgICB8ICAgMSArCnNyYy9pbmNsdWRlL29wdGltaXpl ci9wYXJhbWFzc2lnbi5oICAgICAgICAgICAgfCAgIDIgKwpzcmMvaW5jbHVkZS9wYXJzZXIvYW5h bHl6ZS5oICAgICAgICAgICAgICAgICAgIHwgICA1ICstCnNyYy9pbmNsdWRlL3BhcnNlci9wYXJz ZV9ub2RlLmggICAgICAgICAgICAgICAgfCAgIDcgKwpzcmMvaW5jbHVkZS9wYXJzZXIvcGFyc2Vf cmVsYXRpb24uaCAgICAgICAgICAgIHwgICAxICsKc3JjL2luY2x1ZGUvcmV3cml0ZS9yZXdyaXRl TWFuaXAuaCAgICAgICAgICAgICB8ICAgMSArCnNyYy9pbnRlcmZhY2VzL2VjcGcvcHJlcHJvYy9w YXJzZS5wbCAgICAgICAgICAgfCAgIDQgKy0Kc3JjL3Rlc3QvaXNvbGF0aW9uL2V4cGVjdGVkL21l cmdlLXVwZGF0ZS5vdXQgICB8ICA1MiArLS0Kc3JjL3Rlc3QvaXNvbGF0aW9uL3NwZWNzL21lcmdl LXVwZGF0ZS5zcGVjICAgICB8ICAgNCArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL21lcmdl Lm91dCAgICAgICAgICAgIHwgIDk2ICsrLS0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcmV0 dXJuaW5nLm91dCAgICAgICAgfCA1NjMgKysrKysrKysrKysrKysrKysrKysrKysrKwpzcmMvdGVz dC9yZWdyZXNzL2V4cGVjdGVkL3J1bGVzLm91dCAgICAgICAgICAgIHwgIDIwICstCnNyYy90ZXN0 L3JlZ3Jlc3MvZXhwZWN0ZWQvdXBkYXRhYmxlX3ZpZXdzLm91dCAgfCAyNDAgKysrKysrLS0tLS0K c3JjL3Rlc3QvcmVncmVzcy9zcWwvbWVyZ2Uuc3FsICAgICAgICAgICAgICAgICB8ICAxOCArLQpz cmMvdGVzdC9yZWdyZXNzL3NxbC9yZXR1cm5pbmcuc3FsICAgICAgICAgICAgIHwgMjE4ICsrKysr KysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvcnVsZXMuc3FsICAgICAgICAgICAgICAgICB8ICAg OCArLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC91cGRhdGFibGVfdmlld3Muc3FsICAgICAgIHwgIDUw ICsrLQpzcmMvdG9vbHMvcGdpbmRlbnQvdHlwZWRlZnMubGlzdCAgICAgICAgICAgICAgIHwgICA2 ICsKNjEgZmlsZXMgY2hhbmdlZCwgMjkxMCBpbnNlcnRpb25zKCspLCAzOTAgZGVsZXRpb25zKC0p Cgo= --===============8021987912589445126==--