--- title: DELETE FOR PORTION OF – select * from depesz; | daily.dev description: PostgreSQL 19 introduces the UPDATE/DELETE FOR PORTION OF syntax for temporal tables, allowing targeted modifications to a specific time range within a row's... canonical: https://daily.dev/posts/delete-for-portion-of-select-from-depesz--ubqzjkws1 twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: DELETE FOR PORTION OF – select * from depesz; | daily.dev og:description: PostgreSQL 19 introduces the UPDATE/DELETE FOR PORTION OF syntax for temporal tables, allowing targeted modifications to a specific time range within a row's... og:url: https://daily.dev/posts/delete-for-portion-of-select-from-depesz--ubqzjkws1 og:image: https://api.daily.dev/og/posts/ubQZjkws1.png og:image:alt: DELETE FOR PORTION OF – select * from depesz; og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # DELETE FOR PORTION OF – select * from depesz; **[depesz](https://daily.dev/sources/depesz)** · 7 min read · 0 upvotes · 0 comments ## Summary PostgreSQL 19 introduces the UPDATE/DELETE FOR PORTION OF syntax for temporal tables, allowing targeted modifications to a specific time range within a row's history. Previously, updating a temporally-tracked row required manually closing the old range and inserting a new row inside a transaction. With FOR PORTION OF, a single statement handles the range splitting automatically, inserting 'temporal leftover' rows for history outside the targeted bounds. The feature works for both future and past time ranges, enabling retroactive corrections to historical data. Practical SQL examples demonstrate updating and deleting rows within specific date ranges using tstzrange columns. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [PostgreSQL as a temporal database](https://daily.dev/posts/postgresql-as-a-temporal-database-ypp4bfcv5) · Planet PostgreSQL · 0 upvotes · 0 comments - [Looking Forward to Postgres 19: It's About Time](https://daily.dev/posts/looking-forward-to-postgres-19-it-s-about-time-chhpnhwmp) · Planet PostgreSQL · 0 upvotes · 0 comments - [PostgreSQL 18 - Temporal Constraints](https://daily.dev/posts/postgresql-18---temporal-constraints-bygll79le) · Hashrocket · 32 upvotes · 1 comments - [Waiting for PostgreSQL 19 – Support COPY TO for partitioned tables. – select \* from depesz;](https://daily.dev/posts/waiting-for-postgresql-19-support-copy-to-for-partitioned-tables-select-from-depesz--ryskyymw6) · depesz · 6 upvotes · 0 comments --- Tags: [#backend](https://daily.dev/tags/backend), [#sql](https://daily.dev/tags/sql), [#postgresql](https://daily.dev/tags/postgresql) [View this post on daily.dev](https://daily.dev/posts/delete-for-portion-of-select-from-depesz--ubqzjkws1) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"DELETE FOR PORTION OF – select * from depesz;","url":"https://daily.dev/posts/delete-for-portion-of-select-from-depesz--ubqzjkws1","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/delete-for-portion-of-select-from-depesz--ubqzjkws1"},"datePublished":"2026-04-02T10:55:40.030Z","dateModified":"2026-04-02T10:56:09.721Z","description":"PostgreSQL 19 introduces the UPDATE/DELETE FOR PORTION OF syntax for temporal tables, allowing targeted modifications to a specific time range within a row's...","image":"https://media.daily.dev/image/upload/s--CxzD6vbw--/f_auto/v1722860399/public/Placeholder%2005","thumbnailUrl":"https://media.daily.dev/image/upload/s--CxzD6vbw--/f_auto/v1722860399/public/Placeholder%2005","isAccessibleForFree":true,"articleSection":"depesz","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"depesz","logo":"https://media.daily.dev/image/upload/s--ir7juGOi--/f_auto/v1758461024/logos/depesz","url":"https://daily.dev/sources/depesz"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/delete-for-portion-of-select-from-depesz--ubqzjkws1","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"backend,sql,postgresql","timeRequired":"PT7M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"depesz","item":"https://daily.dev/sources/depesz"},{"@type":"ListItem","position":3,"name":"DELETE FOR PORTION OF – select * from depesz;"}]} ```