# ignore

Published articles for ignore.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Waiting for PostgreSQL 19 - Add IGNORE NULLS/RESPECT NULLS option to Window functions.

DevFeed: [Waiting for PostgreSQL 19 - Add IGNORE NULLS/RESPECT NULLS option to Window functions.](<https://devfeed.tech/articles/waiting-for-postgresql-19-add-ignore-nulls-respect-nulls-option-to-window-functions-33665.md>)

Original publisher: [Read original article](<https://www.depesz.com/2025/10/13/waiting-for-postgresql-19-add-ignore-nulls-respect-nulls-option-to-window-functions/>)

Author: depesz

Published: 2025-10-13T11:13:52Z

Content type: article

Language: en

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

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

Tags: [first-value](<https://devfeed.tech/tags/first-value.md>), [functions](<https://devfeed.tech/tags/functions.md>), [ignore](<https://devfeed.tech/tags/ignore.md>), [lag](<https://devfeed.tech/tags/lag.md>), [last-value](<https://devfeed.tech/tags/last-value.md>), [lead](<https://devfeed.tech/tags/lead.md>), [nth-value](<https://devfeed.tech/tags/nth-value.md>), [null](<https://devfeed.tech/tags/null.md>), [nulls](<https://devfeed.tech/tags/nulls.md>), [pg19](<https://devfeed.tech/tags/pg19.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [waiting](<https://devfeed.tech/tags/waiting.md>), [window](<https://devfeed.tech/tags/window.md>), [window-functions](<https://devfeed.tech/tags/window-functions.md>)

### AI overview

The article describes a PostgreSQL patch adding IGNORE NULLS and RESPECT NULLS options, also called a null treatment clause, to the lead, lag, first_value, last_value, and nth_value window functions. IGNORE NULLS skips NULL values, while RESPECT NULLS remains the default behavior.

### Source excerpt

On 3rd of October 2025, Tatsuo Ishii committed patch: Add IGNORE NULLS/RESPECT NULLS option to Window functions. Add IGNORE NULLS/RESPECT NULLS option (null treatment clause) to lead, lag, first_value, last_value and nth_value window functions. If unspecified, the default is RESPECT NULLS which includes NULL values in any result calculation. IGNORE NULLS ignores NULL values. ... Continue reading "Waiting for PostgreSQL 19 - Add IGNORE NULLS/RESPECT NULLS option to Window functions."