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.96) (envelope-from ) id 1vqTV3-00BUZw-13 for pgsql-committers@arkaria.postgresql.org; Thu, 12 Feb 2026 10:00:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vqTV2-007i9O-0H for pgsql-committers@arkaria.postgresql.org; Thu, 12 Feb 2026 10:00:40 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vqTV1-007i9G-2n for pgsql-committers@lists.postgresql.org; Thu, 12 Feb 2026 10:00:40 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vqTV0-00000000GQw-0H4K for pgsql-committers@lists.postgresql.org; Thu, 12 Feb 2026 10:00:39 +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.96) (envelope-from ) id 1vqTV0-000nu8-0J for pgsql-committers@lists.postgresql.org; Thu, 12 Feb 2026 10:00:38 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vqTUz-000MJ9-0T for pgsql-committers@lists.postgresql.org; Thu, 12 Feb 2026 10:00:38 +0000 Content-Type: multipart/mixed; boundary="===============6197749140747475963==" MIME-Version: 1.0 From: Dean Rasheed To: pgsql-committers@lists.postgresql.org Subject: pgsql: Add support for INSERT ... ON CONFLICT DO SELECT. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 12 Feb 2026 10:00:38 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6197749140747475963== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRkIHN1cHBvcnQgZm9yIElOU0VSVCAuLi4gT04gQ09ORkxJQ1QgRE8gU0VMRUNULgoKVGhpcyBh ZGRzIGEgbmV3IE9OIENPTkZMSUNUIGFjdGlvbiBETyBTRUxFQ1QgW0ZPUiBVUERBVEUvU0hBUkVd LCB3aGljaApyZXR1cm5zIHRoZSBwcmUtZXhpc3Rpbmcgcm93cyB3aGVuIGNvbmZsaWN0cyBhcmUg ZGV0ZWN0ZWQuIFRoZSBJTlNFUlQKc3RhdGVtZW50IG11c3QgaGF2ZSBhIFJFVFVSTklORyBjbGF1 c2UsIHdoZW4gRE8gU0VMRUNUIGlzIHNwZWNpZmllZC4KClRoZSBvcHRpb25hbCBGT1IgVVBEQVRF L1NIQVJFIGNsYXVzZSBhbGxvd3MgdGhlIHJvd3MgdG8gYmUgbG9ja2VkCmJlZm9yZSB0aGV5IGFy ZSBhcmUgcmV0dXJuZWQuIEFzIHdpdGggYSBETyBVUERBVEUgY29uZmxpY3QgYWN0aW9uLCBhbgpv cHRpb25hbCBXSEVSRSBjbGF1c2UgbWF5IGJlIHVzZWQgdG8gcHJldmVudCByb3dzIGZyb20gYmVp bmcgc2VsZWN0ZWQKZm9yIHJldHVybiAoYnV0IGFzIHdpdGggYSBETyBVUERBVEUgYWN0aW9uLCBy b3dzIGZpbHRlcmVkIG91dCBieSB0aGUKV0hFUkUgY2xhdXNlIGFyZSBzdGlsbCBsb2NrZWQpLgoK QnVtcHMgY2F0dmVyc2lvbiBhcyBzdG9yZWQgcnVsZXMgY2hhbmdlLgoKQXV0aG9yOiBBbmRyZWFz IEthcmxzc29uIDxhbmRyZWFzQHByb3hlbC5zZT4KQXV0aG9yOiBNYXJrbyBUaWlra2FqYSA8bWFy a29Aam9oLnRvPgpBdXRob3I6IFZpa3RvciBIb2xtYmVyZyA8dkB2aWt0b3JoLm5ldD4KUmV2aWV3 ZWQtYnk6IEpvZWwgSmFjb2Jzb24gPGpvZWxAY29tcGlsZXIub3JnPgpSZXZpZXdlZC1ieTogS2ly aWxsIFJlc2hrZSA8cmVzaGtla2lyaWxsQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IERlYW4gUmFz aGVlZCA8ZGVhbi5hLnJhc2hlZWRAZ21haWwuY29tPgpSZXZpZXdlZC1ieTogSmlhbiBIZSA8amlh bi51bml2ZXJzYWxpdHlAZ21haWwuY29tPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9t L2Q2MzFiNDA2LTEzYjctNDMzZS04YzBiLWM2MDQwYzRiNDY2M0BTcGFyawpEaXNjdXNzaW9uOiBo dHRwczovL3Bvc3Rnci5lcy9tLzVmY2EyMjJkLTYyYWUtNGEyZi05ZmNiLTBlY2E1NjI3NzA5NEBT cGFyawpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzJiNWRiMmU2LThlY2UtNDRkMC05 ODkwLWYyNTZmZGNhOWY3ZUBwcm94ZWwuc2UKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMv bS9DQUw5c21MQ2RWLXYzS2dPSlgzbVUxOUZZSzgyTjd5enFKajJIQXdXWDcwRT1QOThrZ1FAbWFp bC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6 Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi84ODMyNzA5MmZmMDZjNDg2NzZkMmE2 MDM0MjAwODliZjQ5Mzc3MGYzCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpjb250cmli L3Bvc3RncmVzX2Zkdy9wb3N0Z3Jlc19mZHcuYyAgICAgICAgICAgICAgICB8ICAgMiArLQpkb2Mv c3JjL3NnbWwvZG1sLnNnbWwgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8ICAgMiArLQpk b2Mvc3JjL3NnbWwvZmR3aGFuZGxlci5zZ21sICAgICAgICAgICAgICAgICAgICAgICB8ICAgMiAr LQpkb2Mvc3JjL3NnbWwvbXZjYy5zZ21sICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8ICAx MiArCmRvYy9zcmMvc2dtbC9wb3N0Z3Jlcy1mZHcuc2dtbCAgICAgICAgICAgICAgICAgICAgIHwg ICAyICstCmRvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX3BvbGljeS5zZ21sICAgICAgICAgICAgICAg IHwgIDI5ICstCmRvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX3ZpZXcuc2dtbCAgICAgICAgICAgICAg ICAgIHwgICA0ICstCmRvYy9zcmMvc2dtbC9yZWYvaW5zZXJ0LnNnbWwgICAgICAgICAgICAgICAg ICAgICAgIHwgMTM1ICsrKysrKy0tCmRvYy9zcmMvc2dtbC9yZWYvbWVyZ2Uuc2dtbCAgICAgICAg ICAgICAgICAgICAgICAgIHwgICAzICstCnNyYy9iYWNrZW5kL2FjY2Vzcy9oZWFwL2hlYXBhbS5j ICAgICAgICAgICAgICAgICAgIHwgICA4ICstCnNyYy9iYWNrZW5kL2NvbW1hbmRzL2V4cGxhaW4u YyAgICAgICAgICAgICAgICAgICAgIHwgIDM2ICstCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2V4ZWNJ bmRleGluZy5jICAgICAgICAgICAgICAgIHwgICA2ICstCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2V4 ZWNQYXJ0aXRpb24uYyAgICAgICAgICAgICAgIHwgMTM0ICsrKysrLS0tCnNyYy9iYWNrZW5kL2V4 ZWN1dG9yL25vZGVNb2RpZnlUYWJsZS5jICAgICAgICAgICAgIHwgMzc1ICsrKysrKysrKysrKysr KystLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9jcmVhdGVwbGFuLmMgICAgICAgICAg ICB8ICAgNCArCnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL3NldHJlZnMuYyAgICAgICAgICAg ICAgIHwgICA1ICstCnNyYy9iYWNrZW5kL29wdGltaXplci91dGlsL3BsYW5jYXQuYyAgICAgICAg ICAgICAgIHwgIDI3ICstCnNyYy9iYWNrZW5kL3BhcnNlci9hbmFseXplLmMgICAgICAgICAgICAg ICAgICAgICAgIHwgIDU0ICsrLQpzcmMvYmFja2VuZC9wYXJzZXIvZ3JhbS55ICAgICAgICAgICAg ICAgICAgICAgICAgICB8ICAyMCArLQpzcmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfY2xhdXNlLmMg ICAgICAgICAgICAgICAgICB8ICAxNCArLQpzcmMvYmFja2VuZC9yZXdyaXRlL3Jld3JpdGVIYW5k bGVyLmMgICAgICAgICAgICAgICB8ICAyNyArLQpzcmMvYmFja2VuZC9yZXdyaXRlL3Jvd3NlY3Vy aXR5LmMgICAgICAgICAgICAgICAgICB8IDExMSArKystLS0Kc3JjL2JhY2tlbmQvdXRpbHMvYWR0 L3J1bGV1dGlscy5jICAgICAgICAgICAgICAgICAgfCAgNzcgKysrLS0Kc3JjL2luY2x1ZGUvY2F0 YWxvZy9jYXR2ZXJzaW9uLmggICAgICAgICAgICAgICAgICAgfCAgIDIgKy0Kc3JjL2luY2x1ZGUv bm9kZXMvZXhlY25vZGVzLmggICAgICAgICAgICAgICAgICAgICAgfCAgMTMgKy0Kc3JjL2luY2x1 ZGUvbm9kZXMvbG9ja29wdGlvbnMuaCAgICAgICAgICAgICAgICAgICAgfCAgIDMgKy0Kc3JjL2lu Y2x1ZGUvbm9kZXMvbm9kZXMuaCAgICAgICAgICAgICAgICAgICAgICAgICAgfCAgIDEgKwpzcmMv aW5jbHVkZS9ub2Rlcy9wYXJzZW5vZGVzLmggICAgICAgICAgICAgICAgICAgICB8ICAxMCArLQpz cmMvaW5jbHVkZS9ub2Rlcy9wbGFubm9kZXMuaCAgICAgICAgICAgICAgICAgICAgICB8ICAgNCAr LQpzcmMvaW5jbHVkZS9ub2Rlcy9wcmltbm9kZXMuaCAgICAgICAgICAgICAgICAgICAgICB8ICAx MiArLQouLi4vZXhwZWN0ZWQvaW5zZXJ0LWNvbmZsaWN0LWRvLXNlbGVjdC5vdXQgICAgICAgICB8 IDEzOCArKysrKysrKwpzcmMvdGVzdC9pc29sYXRpb24vaXNvbGF0aW9uX3NjaGVkdWxlICAgICAg ICAgICAgICB8ICAgMSArCi4uLi9pc29sYXRpb24vc3BlY3MvaW5zZXJ0LWNvbmZsaWN0LWRvLXNl bGVjdC5zcGVjIHwgIDUzICsrKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2NvbnN0cmFpbnRz Lm91dCAgICAgICAgICB8ICAgNCArCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvaW5zZXJ0X2Nv bmZsaWN0Lm91dCAgICAgIHwgMjE2ICsrKysrKysrKysrLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVj dGVkL3ByaXZpbGVnZXMub3V0ICAgICAgICAgICB8ICAyNiArKwpzcmMvdGVzdC9yZWdyZXNzL2V4 cGVjdGVkL3Jvd3NlY3VyaXR5Lm91dCAgICAgICAgICB8ICA5NCArKysrKy0Kc3JjL3Rlc3QvcmVn cmVzcy9leHBlY3RlZC9ydWxlcy5vdXQgICAgICAgICAgICAgICAgfCAgNTUgKysrCnNyYy90ZXN0 L3JlZ3Jlc3MvZXhwZWN0ZWQvdHJpZ2dlcnMub3V0ICAgICAgICAgICAgIHwgIDEwICstCnNyYy90 ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvdXBkYXRhYmxlX3ZpZXdzLm91dCAgICAgIHwgIDgyICsrKyst CnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2NvbnN0cmFpbnRzLnNxbCAgICAgICAgICAgICAgIHwgICAz ICsKc3JjL3Rlc3QvcmVncmVzcy9zcWwvaW5zZXJ0X2NvbmZsaWN0LnNxbCAgICAgICAgICAgfCAg NzQgKysrLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC9wcml2aWxlZ2VzLnNxbCAgICAgICAgICAgICAg ICB8ICAxOCArCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3Jvd3NlY3VyaXR5LnNxbCAgICAgICAgICAg ICAgIHwgIDU3ICsrKy0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvcnVsZXMuc3FsICAgICAgICAgICAg ICAgICAgICAgfCAgMjYgKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvdHJpZ2dlcnMuc3FsICAgICAg ICAgICAgICAgICAgfCAgIDMgKy0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvdXBkYXRhYmxlX3ZpZXdz LnNxbCAgICAgICAgICAgfCAgMzEgKy0Kc3JjL3Rvb2xzL3BnaW5kZW50L3R5cGVkZWZzLmxpc3Qg ICAgICAgICAgICAgICAgICAgfCAgIDIgKy0KNDggZmlsZXMgY2hhbmdlZCwgMTY3NSBpbnNlcnRp b25zKCspLCAzNTIgZGVsZXRpb25zKC0pCgo= --===============6197749140747475963==--