Re: SQL:2011 Application Time Update & Delete

On Fri, Feb 13, 2026 at 12:00 PM Paul A Jungwirth
<pj(at)illuminatedcomputing(dot)com> wrote:
>
> Here is another round to fix a few rebase conflicts.

I realized we didn't have any tests for v18's new feature to say
`UPDATE ... RETURNING OLD.foo, NEW.foo`. These patches add a small
test for `RETURNING OLD.valid_at, NEW.valid_at` when you say `UPDATE
FOR PORTION OF valid_at`. This seems worth testing since that column
gets set in an automatic way, not via the normal SET syntax. No fixes
were needed.

I also corrected the commit message, which still referred to the
without_overlaps function that we renamed to
{range,multirange}_minus_multi.

As far as I know nothing else here is waiting on me, but please
correct me if I've overlooked something.

Rebased to 18bcdb75d1.

Yours,

--
Paul ~{:-)
pj(at)illuminatedcomputing(dot)com