Add IGNORE NULLS to Window functions

Edit

5230

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v18, Patch count: 6, First patch: +39−5, All patches: +966−56

Topic

SQL Commands

Tags

Created

2024-09-01 15:00:05

Last modified

2025-08-16 22:28:56 (yesterday)

Latest email

2025-08-16 22:34:19 (yesterday)

Status

PG19-2 (2025-09-01 - 2025-09-30): Ready for Committer

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

Authors

Oliver Ford (ojford)

Reviewers

Tatsuo Ishii (ishii), 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-08-16 22:34:19 by Tatsuo Ishii <ishii at postgresql.org>
Latest 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>
    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-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