Re: IGNORE/RESPECT NULLS can be specified for (prokind == 'f').
Chao Li <li.evan.chao@gmail.com>
From: Chao Li <li.evan.chao@gmail.com>
To: Tatsuo Ishii <ishii@postgresql.org>
Cc: jian.universality@gmail.com,
pgsql-hackers@postgresql.org
Date: 2026-06-17T01:44:33Z
Lists: pgsql-hackers
Attachments
- nocfbot-fix-errmsg.diff (application/octet-stream) patch
> On Jun 17, 2026, at 09:17, Tatsuo Ishii <ishii@postgresql.org> wrote: > >>>> To fix this, ParseFuncOrColumn() now checks whether other than window >>>> functions are used with the null treatment clause. If so, error out. >>>> >>>> Also remove the unnecessary test for "aggregate functions do not >>>> accept RESPECT/IGNORE NULLS" because it is now checked in the >>>> early-stage new check. The window regression test expected file is >>>> changed accordingly. >>> >>> I'm going to push the patch today if there's no objection. >> >> The code looks good to me, and the commit message is clear and well-written. > > Thank you for the review! > I have pushed the patch to master branch. > https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=4e5920e6de87dc1ed761d2a898b7786c50c11db2 > -- > Tatsuo Ishii > SRA OSS K.K. > English: http://www.sraoss.co.jp/index_en/ > Japanese:http://www.sraoss.co.jp > Hi Tatsuo-san, Sorry for jumping in. I didn’t review the patch, but while browsing recent commits, I noticed that this commit has a small issue: the errmsg should start with a lowercase character, according to the error style guide [1]: ``` Primary error messages: Do not capitalize the first letter. Do not end a message with a period. Do not even think about ending a message with an exclamation point. ``` The attached diff is a quick fix that changes “Only” to “only” and updates the expected output accordingly. [1] https://www.postgresql.org/docs/current/error-style-guide.html Best regards, -- Chao Li (Evan) HighGo Software Co., Ltd. https://www.highgo.com/
Commits
-
Remove stray blank line in ParseFuncOrColumn()
- b07664a179bd 19 (unreleased) landed
- d8113095c488 master landed
-
Refine error reporting for null treatment on non-window functions
- 419ce13b7019 19 (unreleased) landed
-
Fix error message typo.
- ab3023ad1e68 19 (unreleased) landed
-
Fix to not allow null treatment to non window functions.
- 4e5920e6de87 19 (unreleased) landed
-
Add IGNORE NULLS/RESPECT NULLS option to Window functions.
- 25a30bbd4235 19 (unreleased) cited