Add IGNORE NULLS to Window functions

Edit
ID 5230
Title Add IGNORE NULLS to Window functions
CI (CFBot) Summary
Stats (from CFBot) Patch count: 1, First patch: +3−1, All patches: +3−1
Topic SQL Commands
Tags
Created 2024-09-01 15:00:05
Last modified 2025-10-03 07:36:22 (1 month ago)
Latest email 2025-09-24 13:18:42 (1 month ago)
Status
PG19-2 (2025-09-01 – 2025-09-30): Committed
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
2025-03 (2025-03-01 – 2025-04-08): Moved to different CF
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
2024-11 (2024-11-01 – 2024-11-30): Moved to different CF
Target version 19
Authors Oliver Ford (ojford)
Reviewers Tatsuo Ishii (ishii), Krasiyan Andreev (krasiyan)Become reviewer
Committer Tatsuo Ishii (ishii)
Links
Emails
Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options
First at 2018-07-13 12:52:00 by Oliver Ford <ojford at gmail.com>
Latest at 2025-09-24 13:18:42 by Tatsuo Ishii <ishii at postgresql.org>
Latest attachment (0001-Add-uint8-uint16-to-gen_node_support.patch) at 2025-09-24 12:24:02 from Oliver Ford <ojford at gmail.com>
    Attachment (0001-Add-uint8-uint16-to-gen_node_support.patch) at 2025-09-24 12:24:02 from Oliver Ford <ojford at gmail.com> (Patch: Yes)
    Attachment (v19-0001-Modify-parse-analysis-modules-to-accept-RESPECT-.patch) at 2025-09-24 05:39:00 from Tatsuo Ishii <ishii at postgresql.org> (Patch: Yes)
    Attachment (v18-0001-Modify-parse-analysis-modules-to-accept-RESPECT-.patch) at 2025-08-16 09:33:29 from Tatsuo Ishii <ishii at postgresql.org> (Patch: Yes)
    Attachment (v17-0001-Modify-parse-analysis-modules-to-accept-RESPECT-.patch) at 2025-07-25 07:49:14 from Tatsuo Ishii <ishii at postgresql.org> (Patch: Yes)
    Attachment (unknown_filename) at 2025-07-16 04:44:07 from Tatsuo Ishii <ishii at postgresql.org> (Patch: No)
    Attachment (v16-0001-Add-IGNORE-NULLS-RESPECT-NULLS-option-to-Window-.patch) at 2025-07-07 05:37:37 from Tatsuo Ishii <ishii at postgresql.org> (Patch: Yes)
    Attachment (v15-0001-Add-IGNORE-NULLS-RESPECT-NULLS-option-to-Window-.patch) at 2025-06-30 05:25:56 from Tatsuo Ishii <ishii at postgresql.org> (Patch: Yes)
    Attachment (v14-0001-Add-IGNORE-NULLS-RESPECT-NULLS-option-to-Window-.patch) at 2025-06-25 07:19:03 from Tatsuo Ishii <ishii at postgresql.org> (Patch: Yes)
    Attachment (v13-0001-Add-IGNORE-NULLS-RESPECT-NULLS-option-to-Window-.patch) at 2025-06-19 06:21:11 from Tatsuo Ishii <ishii at postgresql.org> (Patch: Yes)
    Attachment (v12-0001-Add-IGNORE-NULLS-RESPECT-NULLS-option-to-Window-.patch) at 2025-06-11 22:52:35 from Tatsuo Ishii <ishii at postgresql.org> (Patch: Yes)
    Attachment (0011-ignore-nulls.patch) at 2025-03-13 07:49:03 from Oliver Ford <ojford at gmail.com> (Patch: Yes)
    Attachment (0010-ignore-nulls.patch) at 2025-03-09 20:07:33 from Oliver Ford <ojford at gmail.com> (Patch: Yes)
    Attachment (0009-ignore-nulls.patch) at 2025-03-06 09:57:30 from Oliver Ford <ojford at gmail.com> (Patch: Yes)
    Attachment (ignore_nulls_bench_graph.png) at 2025-02-28 11:48:51 from Tatsuo Ishii <ishii at postgresql.org> (Patch: No)
    Attachment (0008-ignore.patch) at 2025-02-18 16:50:30 from Oliver Ford <ojford at gmail.com> (Patch: Yes)
    Attachment (0007-ignore-nulls.patch) at 2025-02-13 15:02:57 from Oliver Ford <ojford at gmail.com> (Patch: Yes)
    Attachment (0006-ignore-nulls.patch) at 2025-01-27 16:19:30 from Oliver Ford <ojford at gmail.com> (Patch: Yes)
    Attachment (0005-ignore-nulls.patch) at 2025-01-24 08:27:09 from Oliver Ford <ojford at gmail.com> (Patch: Yes)
    Attachment (0004-ignore-nulls.patch) at 2025-01-21 21:14:55 from Oliver Ford <ojford at gmail.com> (Patch: Yes)
    Attachment (unknown_filename) at 2025-01-19 23:55:17 from Tatsuo Ishii <ishii at postgresql.org> (Patch: Yes)
    Attachment (0003-ignore-nulls.patch) at 2025-01-17 16:43:29 from Oliver Ford <ojford at gmail.com> (Patch: Yes)
    Attachment (0002-add-ignore_nulls.patch) at 2024-09-09 09:49:11 from Oliver Ford <ojford at gmail.com> (Patch: Yes)
    Attachment (0001-add-ignore_nulls.patch) at 2024-09-07 20:25:28 from Oliver Ford <ojford at gmail.com> (Patch: Yes)
    Attachment (reject_null_treatment.patch) at 2023-05-06 03:57:25 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (0001-initial-window-ignore.patch) at 2023-05-01 11:57:38 from Oliver Ford <ojford at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Implement-IGNORE-or-RESPECT-NULLS-parse-analysis-.patch) at 2023-04-22 12:14:43 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (pg13_ignore_nulls.patch) at 2020-04-30 19:50:00 from Krasiyan Andreev <krasiyan at gmail.com> (Patch: Yes)
    Attachment (0001-RESPECT-IGNORE-NULLS-FIRST-LAST-in-windowing-functio.patch) at 2018-07-28 18:59:58 from David Fetter <david at fetter.org> (Patch: Yes)
    Attachment (0001-respect.patch) at 2018-07-13 12:52:00 from Oliver Ford <ojford at gmail.com> (Patch: Yes)
History
When Who What
2025-10-03 07:36:22 Tatsuo Ishii (ishii) Closed in commitfest PG19-2 with status: Committed
2025-10-03 07:36:22 Tatsuo Ishii (ishii) Changed committer to ishii
2025-08-16 22:28:56 Tatsuo Ishii (ishii) Moved from CF PG19-1 to CF PG19-2
2025-07-01 00:14:40 Tatsuo Ishii (ishii) Changed targetversion to 19
2025-06-26 10:20:46 Tatsuo Ishii (ishii) Added ishii as reviewer
2025-03-09 20:17:23 Oliver Ford (ojford) New status: Ready for Committer
2025-02-27 10:49:25 Oliver Ford (ojford) Closed in commitfest 2025-03 with status: Moved to next CF
2025-02-27 10:49:16 Oliver Ford (ojford) Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-28 16:11:56 Krasiyan Andreev (krasiyan) Added krasiyan as reviewer
2024-12-11 04:14:13 Michael Paquier (michael-kun) Closed in commitfest 2024-11 with status: Moved to next CF
2024-09-09 12:02:07 Oliver Ford (ojford) Attached mail thread CAGMVOdsbtRwE_4+v8zjH1d9xfovDeQAGLkP_B6k69_VoFEgX-A@mail.gmail.com
2024-09-09 12:01:56 Oliver Ford (ojford) Detached mail thread CAGMVOdsbtRwE_4+v8zjH1d9xfovDeQAGLkP_B6k69_VoFEgX-A@mail.gmail.com
2024-09-09 10:45:28 Oliver Ford (ojford) Attached mail thread CAGMVOdsbtRwE_4+v8zjH1d9xfovDeQAGLkP_B6k69_VoFEgX-A@mail.gmail.com
2024-09-09 10:45:22 Oliver Ford (ojford) Detached mail thread CAGMVOdsbtRwE_4+v8zjH1d9xfovDeQAGLkP_B6k69_VoFEgX-A@mail.gmail.com
2024-09-09 09:53:36 Oliver Ford (ojford) Attached mail thread CAGMVOdsbtRwE_4+v8zjH1d9xfovDeQAGLkP_B6k69_VoFEgX-A@mail.gmail.com
2024-09-09 09:53:30 Oliver Ford (ojford) Detached mail thread CAGMVOdsbtRwE_4+v8zjH1d9xfovDeQAGLkP_B6k69_VoFEgX-A@mail.gmail.com
2024-09-09 09:51:01 Oliver Ford (ojford) Attached mail thread CAGMVOdsbtRwE_4+v8zjH1d9xfovDeQAGLkP_B6k69_VoFEgX-A@mail.gmail.com
2024-09-09 09:47:45 Oliver Ford (ojford) Detached mail thread CAGMVOdsbtRwE_4+v8zjH1d9xfovDeQAGLkP_B6k69_VoFEgX-A@mail.gmail.com
2024-09-07 20:27:51 Oliver Ford (ojford) Attached mail thread CAGMVOdsbtRwE_4+v8zjH1d9xfovDeQAGLkP_B6k69_VoFEgX-A@mail.gmail.com
2024-09-07 20:26:04 Oliver Ford (ojford) Detached mail thread CAGMVOdsbtRwE_4+v8zjH1d9xfovDeQAGLkP_B6k69_VoFEgX-A@mail.gmail.com
2024-09-02 10:12:12 Oliver Ford (ojford) Changed authors to Oliver Ford (ojford)
2024-09-01 15:00:18 Oliver Ford (ojford) Changed targetversion to 18
2024-09-01 15:00:05 Oliver Ford (ojford) Attached mail thread CAGMVOdsbtRwE_4+v8zjH1d9xfovDeQAGLkP_B6k69_VoFEgX-A@mail.gmail.com
2024-09-01 15:00:05 Oliver Ford (ojford) Created patch record
Edit