Re: Allow ON CONFLICT DO UPDATE to return EXCLUDED values

On Mon, 7 Jul 2025 at 11:38, Jim Jones <jim(dot)jones(at)uni-muenster(dot)de> wrote:
>
> I'm wondering if the current behaviour with DEFAULT columns should be
> mentioned in the docs.

Hmm, perhaps. On the INSERT page, under "conflict_action", we currently say

Note that the effects of all per-row BEFORE INSERT triggers are
reflected in excluded values, since those effects may have
contributed to the row being excluded from insertion.

perhaps that should say

Note that any values that were supplied by defaults, as well as
the effects of all per-row BEFORE INSERT triggers are reflected
in excluded values, since that may have contributed to the row
being excluded from insertion.

Regards,
Dean