| From: | Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Allow ON CONFLICT DO UPDATE to return EXCLUDED values |
| Date: | 2025-06-30 17:18:28 |
| Message-ID: | CAEZATCUeip1=pH9b29Aaw5o9hQxN2xgYT2HrSVxefb9dj77JZg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, 24 Jun 2025 at 19:49, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> wrote:
>
> The attached patch allows EXCLUDED values to appear in the RETURNING
> list of INSERT ... ON CONFLICT DO UPDATE.
>
> I still have a lot more testing to do, and docs to update, but so far
> the results look promising. I'll add this to the next CF.
>
v2 attached, now with docs and more test cases.
Regards,
Dean
| Attachment | Content-Type | Size |
|---|---|---|
| v2-0001-Allow-EXCLUDED-in-RETURNING-list-of-INSERT-ON-CON.patch | text/x-patch | 100.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shirisha Shirisha | 2025-06-30 17:24:05 | Re: Proposal to allow DELETE/UPDATE on partitioned tables with unsupported foreign partitions |
| Previous Message | Daniel Gustafsson | 2025-06-30 17:01:50 | Re: [PoC] Federated Authn/z with OAUTHBEARER |