Re: Allow ON CONFLICT DO UPDATE to return EXCLUDED values

From: Viktor Holmberg <v(at)viktorh(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Allow ON CONFLICT DO UPDATE to return EXCLUDED values
Date: 2025-10-07 13:55:49
Message-ID: fb18cbb9-32ca-46ea-b2ff-a7e7f20e883c@Spark
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I’ve looked through this patch. As far as I can tell, everything looks good, working and well commented.
The only nitpick I could find is a mispelling "EXLCUDED" → "EXCLUDED" in src/test/regress/expected/returning.out:464.

A maybe bigger question, is it nice that EXCLUDED is null when no conflict occurred? I can see the logic, but I think ergonomics wise it’d be nicer to have the proposed values in EXCLUDED, no matter what happened later. Then one can check EXCLUDED.value = NEW.value to see if one’s changes were added, for example.

/Viktor
On 7 Oct 2025 at 15:43 +0200, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>, wrote:
> Rebased version attached, following 904f6a593a0.
>
> Regards,
> Dean

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Aleksander Alekseev 2025-10-07 14:04:29 [PATCH] ecpg: check return value of replace_variables()
Previous Message Nazir Bilal Yavuz 2025-10-07 13:12:56 Improve docs syntax checking and enable it in the meson build