Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options

From:	Tatsuo Ishii <ishii(at)postgresql(dot)org>
To:	krasiyan(at)gmail(dot)com, ojford(at)gmail(dot)com, tgl(at)sss(dot)pgh(dot)pa(dot)us, vik(at)postgresfriends(dot)org, andrew(at)tao11(dot)riddles(dot)org(dot)uk, david(at)fetter(dot)org
Cc:	pgsql-hackers(at)postgresql(dot)org
Subject:	Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options
Date:	2025-06-30 05:25:56
Message-ID:	20250630.142556.158881195489030489.ishii@postgresql.org
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2018-07-13 12:52:00 from Oliver Ford <ojford(at)gmail(dot)com> 📎  2018-07-28 18:59:58 from David Fetter <david(at)fetter(dot)org> 📎   2018-09-18 12:05:07 from Krasiyan Andreev <krasiyan(at)gmail(dot)com>    2018-09-22 20:06:32 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>     2018-09-23 21:13:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>      2018-09-23 22:22:30 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>       2018-09-23 23:10:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>        2018-09-23 23:46:40 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>         2018-09-24 00:20:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>          2018-09-24 00:26:44 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>        2018-09-25 04:16:27 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>         2018-09-25 14:07:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>          2018-09-27 04:40:27 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>          2023-04-22 12:14:43 from Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> 📎           2023-04-22 12:38:50 from Oliver Ford <ojford(at)gmail(dot)com>           2023-04-22 17:27:06 from Vik Fearing <vik(at)postgresfriends(dot)org>            2023-04-22 17:52:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>             2023-04-23 03:29:24 from Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>              2023-05-01 11:57:38 from Oliver Ford <ojford(at)gmail(dot)com> 📎               2023-05-02 01:03:52 from Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>                2023-05-06 03:57:25 from Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> 📎                 2023-05-06 08:41:49 from Oliver Ford <ojford(at)gmail(dot)com>                  2023-05-06 09:35:34 from Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>                  2024-09-07 20:25:28 from Oliver Ford <ojford(at)gmail(dot)com> 📎                   2024-09-08 13:22:13 from Vik Fearing <vik(at)postgresfriends(dot)org>                    2024-09-09 09:49:11 from Oliver Ford <ojford(at)gmail(dot)com> 📎                     2024-09-12 01:41:07 from Tatsuo Ishii <ishii(at)postgresql(dot)org>                      2024-09-12 02:11:35 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                       2024-09-12 02:30:48 from Tatsuo Ishii <ishii(at)postgresql(dot)org>                      2025-01-17 16:43:29 from Oliver Ford <ojford(at)gmail(dot)com> 📎                       2025-01-19 23:55:17 from Tatsuo Ishii <ishii(at)postgresql(dot)org> 📎                        2025-01-20 00:03:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                         2025-01-20 00:18:25 from Tatsuo Ishii <ishii(at)postgresql(dot)org>                          2025-01-20 00:31:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                           2025-01-20 00:36:44 from Tatsuo Ishii <ishii(at)postgresql(dot)org>                           2025-01-20 19:09:38 from Oliver Ford <ojford(at)gmail(dot)com>                            2025-01-21 01:20:53 from Tatsuo Ishii <ishii(at)postgresql(dot)org>                             2025-01-21 01:44:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                             2025-01-21 21:14:55 from Oliver Ford <ojford(at)gmail(dot)com> 📎                              2025-01-22 11:58:18 from Tatsuo Ishii <ishii(at)postgresql(dot)org>                               2025-01-23 04:25:02 from Tatsuo Ishii <ishii(at)postgresql(dot)org>                                2025-01-23 06:08:39 from Krasiyan Andreev <krasiyan(at)gmail(dot)com>                                 2025-01-23 06:27:41 from Tatsuo Ishii <ishii(at)postgresql(dot)org>                                  2025-01-24 08:27:09 from Oliver Ford <ojford(at)gmail(dot)com> 📎                                   2025-01-27 11:51:15 from Tatsuo Ishii <ishii(at)postgresql(dot)org>                                    2025-01-27 16:19:30 from Oliver Ford <ojford(at)gmail(dot)com> 📎                                     2025-01-28 09:02:32 from Tatsuo Ishii <ishii(at)postgresql(dot)org>                                      2025-01-30 12:02:19 from Oliver Ford <ojford(at)gmail(dot)com>                                       2025-01-31 02:25:57 from Tatsuo Ishii <ishii(at)postgresql(dot)org>                                       2025-02-03 11:45:55 from Tatsuo Ishii <ishii(at)postgresql(dot)org>                                        2025-02-13 15:02:57 from Oliver Ford <ojford(at)gmail(dot)com> 📎                                         2025-02-18 04:19:28 from Tatsuo Ishii <ishii(at)postgresql(dot)org>                                          2025-02-18 16:50:30 from Oliver Ford <ojford(at)gmail(dot)com> 📎                                           2025-02-28 11:48:51 from Tatsuo Ishii <ishii(at)postgresql(dot)org> 📎                                            2025-03-06 09:57:30 from Oliver Ford <ojford(at)gmail(dot)com> 📎                                             2025-03-09 06:39:57 from Tatsuo Ishii <ishii(at)postgresql(dot)org>                                              2025-03-09 20:07:33 from Oliver Ford <ojford(at)gmail(dot)com> 📎                                               2025-03-13 07:49:03 from Oliver Ford <ojford(at)gmail(dot)com> 📎                                                2025-03-29 07:51:55 from Krasiyan Andreev <krasiyan(at)gmail(dot)com>                                                 2025-03-29 11:18:09 from Tatsuo Ishii <ishii(at)postgresql(dot)org>                                                  2025-06-11 22:52:35 from Tatsuo Ishii <ishii(at)postgresql(dot)org> 📎                                                   2025-06-19 06:21:11 from Tatsuo Ishii <ishii(at)postgresql(dot)org> 📎                                                    2025-06-25 07:19:03 from Tatsuo Ishii <ishii(at)postgresql(dot)org> 📎                                                     2025-06-30 05:25:56 from Tatsuo Ishii <ishii(at)postgresql(dot)org> 📎                                                      2025-06-30 08:08:26 from Krasiyan Andreev <krasiyan(at)gmail(dot)com>                                                       2025-07-01 00:19:06 from Tatsuo Ishii <ishii(at)postgresql(dot)org>                                                      2025-07-07 05:37:37 from Tatsuo Ishii <ishii(at)postgresql(dot)org> 📎                                                       2025-07-16 04:44:07 from Tatsuo Ishii <ishii(at)postgresql(dot)org> 📎            2023-04-23 01:24:02 from Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>         2020-04-30 18:58:55 from Stephen Frost <sfrost(at)snowman(dot)net>          2020-04-30 19:50:00 from Krasiyan Andreev <krasiyan(at)gmail(dot)com> 📎    2018-09-27 04:58:48 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v15-0001-Add-IGNORE-NULLS-RESPECT-NULLS-option-to-Window-.patch	application/octet-stream	54.0 KB

In response to

• Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options at 2025-06-25 07:19:03 from Tatsuo Ishii

Responses

• Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options at 2025-06-30 08:08:26 from Krasiyan Andreev
• Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options at 2025-07-07 05:37:37 from Tatsuo Ishii

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Masahiko Sawada	2025-06-30 05:45:37	Re: POC: enable logical decoding when wal_level = 'replica' without a server restart
Previous Message	Michael Paquier	2025-06-30 05:12:57	Re: Addition of %b/backend_type in log_line_prefix of TAP test logs