Add IGNORE NULLS to Window functions

Edit
Comment/Review
Change Status
ID 5230
Title Add IGNORE NULLS to Window functions
CI (CFBot) Summary
Stats (from CFBot) Patch count: 1, First patch: +773−28, All patches: +773−28
Topic SQL Commands
Created 2024-09-01 15:00:05
Last modified 2025-03-09 20:17:23 (3 days, 20 hours ago)
Latest email 2025-03-13 07:49:03 (9 hours, 23 minutes ago)
Status
2025-07: Ready for Committer
2025-03: Moved to next CF
2025-01: Moved to next CF
2024-11: Moved to next CF
Target version 18
Authors Oliver Ford (ojford)
Reviewers Krasiyan Andreev (krasiyan)Become reviewer
Committer
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-03-13 07:49:03 by Oliver Ford <ojford at gmail.com>
Latest attachment (0011-ignore-nulls.patch) at 2025-03-13 07:49:03 from Oliver Ford <ojford at gmail.com>
    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-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
Comment/Review
Change Status