On Fri, 23 Oct 2026 at 09:46, Dean Rasheed <[email protected]> wrote:
>
> RETURNING WITH (OLD AS o, NEW AS n)
> key,
> o.val1, -- Forces old.val1 to be returned regardless of old/new in
> -- triggering query
> n.val2, -- Forces new.val2 to be returned regardless of old/new in
> -- triggering query
Oops, I mis-remembered that. For the record, those comments should read
o.val1, -- Returns old.val1 if triggering query doesn't specify old/new
n.val2, -- Returns new.val2 if triggering query doesn't specify old/new
but that doesn't change any of the arguments that follow.
Regards,
Dean
