Add IGNORE NULLS to Window functions

Edit
Comment/Review
Change Status
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, 1 week ago)
Latest email 2025-01-17 16:43:29 (12 hours, 31 minutes 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-17 16:43:29 by Oliver Ford <ojford at gmail.com>
Latest attachment (0003-ignore-nulls.patch) at 2025-01-17 16:43:29 from Oliver Ford <ojford at gmail.com>
    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
Comment/Review
Change Status