# PostgreSQL temporal UPDATE and DELETE by range

DevFeed: [PostgreSQL temporal UPDATE and DELETE by range](<https://devfeed.tech/articles/waiting-for-postgresql-19-add-update-delete-for-portion-of-33685.md>)

Original publisher: [Read original article](<https://www.depesz.com/2026/04/02/waiting-for-postgresql-19-add-update-delete-for-portion-of/>)

Author: depesz

Published: 2026-04-02T10:51:21Z

Content type: tutorial

Language: en

Sources: [select \* from depesz;](<https://devfeed.tech/sources/select-from-depesz.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [postgresql 18](<https://devfeed.tech/topics/postgresql-18.md>)

Tags: [delete](<https://devfeed.tech/tags/delete.md>), [period](<https://devfeed.tech/tags/period.md>), [pg19](<https://devfeed.tech/tags/pg19.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [query](<https://devfeed.tech/tags/query.md>), [range](<https://devfeed.tech/tags/range.md>), [temporal](<https://devfeed.tech/tags/temporal.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [update](<https://devfeed.tech/tags/update.md>), [version](<https://devfeed.tech/tags/version.md>), [waiting](<https://devfeed.tech/tags/waiting.md>)

## AI overview

This article explains a PostgreSQL patch that extends UPDATE and DELETE for temporal tables, allowing changes or deletions over a specified range or multirange period. The article also notes that the patch was later reverted after discussion.

## Source excerpt

Important update This has been reverted with some discussion. Thanks for ping to mkurz 🙂 On 1st of April 2026, Peter Eisentraut committed patch: Add UPDATE/DELETE FOR PORTION OF This is an extension of the UPDATE and DELETE commands to do a "temporal update/delete" based on a range or multirange column. The user can ... Continue reading "Waiting for PostgreSQL 19 - Add UPDATE/DELETE FOR PORTION OF"