Add IGNORE NULLS and FROM LAST options

Edit
ID 1724
Title Add IGNORE NULLS and FROM LAST options
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic SQL Commands
Tags
Created 2018-07-13 13:58:01
Last modified 2018-09-30 18:57:09 (7 years ago)
Latest email 2025-09-24 13:18:42 (1 month ago)
Status
2018-09 (2018-09-01 – 2018-09-30): Returned with feedback
Target version
Authors Oliver Ford (ojford)
Reviewers Krasiyan Andreev (krasiyan)Become reviewer
Committer Andrew Gierth (rhodiumtoad)
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
2018-09-30 18:57:09 Andrew Gierth (rhodiumtoad) Closed in commitfest 2018-09 with status: Returned with feedback
2018-09-18 12:45:20 Andrew Gierth (rhodiumtoad) Added rhodiumtoad as committer
2018-09-18 11:44:13 Krasiyan Andreev (krasiyan) New status: Ready for Committer
2018-07-16 08:26:43 Oliver Ford (ojford) Changed topic to SQL Commands
2018-07-13 13:58:25 Oliver Ford (ojford) Changed authors to Oliver Ford (ojford)
2018-07-13 13:58:25 Oliver Ford (ojford) Changed reviewers to Krasiyan Andreev (krasiyan)
2018-07-13 13:58:01 Oliver Ford (ojford) Attached mail thread CAGMVOdsbtRwE_4+v8zjH1d9xfovDeQAGLkP_B6k69_VoFEgX-A@mail.gmail.com
2018-07-13 13:58:01 Oliver Ford (ojford) Created patch record
Edit