Add IGNORE NULLS to Window functions

Edit

ID 5230

Title Add IGNORE NULLS to Window functions

Topic SQL Commands

Created 2024-09-01 15:00:05

Last modified 2024-12-11 04:14:13 (1 month, 2 weeks ago)

Latest email 2025-01-28 09:02:32 (1 day, 12 hours ago)

Status

2025-01: Needs review

2024-11: Moved to next CF

Target version 18

Authors Oliver Ford (ojford)

Reviewers Krasiyan Andreev (krasiyan)Become reviewer

Committer

Links CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/5230
git checkout commitfest/cf/5230

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-01-28 09:02:32 by Tatsuo Ishii <ishii at postgresql.org>
Latest attachment (0006-ignore-nulls.patch) at 2025-01-27 16:19:30 from Oliver Ford <ojford at gmail.com>
    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
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