Re: Allow ON CONFLICT DO UPDATE to return EXCLUDED values

Dean Rasheed <dean.a.rasheed@gmail.com>

From: Dean Rasheed <dean.a.rasheed@gmail.com>

To: PostgreSQL Hackers <pgsql-hackers@postgresql.org>

Date: 2025-06-30T17:18:28Z

Lists: pgsql-hackers

Attachments

v2-0001-Allow-EXCLUDED-in-RETURNING-list-of-INSERT-ON-CON.patch (text/x-patch) patch v2-0001

On Tue, 24 Jun 2025 at 19:49, Dean Rasheed <dean.a.rasheed@gmail.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