November 19, 2026: PostgreSQL 19 Released!

Feature Description

IGNORE NULLS / RESPECT NULLS for window functions

The lead(), lag(), first_value(), last_value(), and nth_value() window functions can skip NULL values using IGNORE NULLS.