Add IGNORE NULLS to Window functions

Log in to 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
Tags SQL Commands
Created 2024-09-01 15:00:05
Last modified 2025-10-03 07:36:22 (1 year ago)
Latest email 2025-09-24 13:18:42 (1 year 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) Log in to 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
Log in to edit