Hubert (depesz) Lubaczewski • 4/2/2026

Waiting for PostgreSQL 19 – Add UPDATE/DELETE FOR PORTION OF

This article discusses a new PostgreSQL 19 feature: UPDATE/DELETE FOR PORTION OF, which extends temporal table capabilities introduced in PostgreSQL 18. It allows users to perform temporal updates and deletes on range or multirange columns, automatically handling row truncation and insertion of 'temporal leftovers' for partially affected history. The article includes a code example showing the old manual approach versus the new simplified syntax, covering bison support, executor logic, and documentation. This is a technical update for database developers and PostgreSQL enthusiasts.

0 comments

#postgresql #SQL Syntax #Range Types