Tatsuo Ishii <is...@postgresql.org> writes: > It needs lots of work including modifying CREATE FUNCTION > command. Instead you could add an API to WinObject access functions to > export ignore_nulls value. Then let each window function check it. If > the window function should not take IGNORE/RESPECT NULLS option, throw > an error.
Yeah, that would be my first thought too. The only question is whether a function that fails to check that could crash. If it merely gives surprising answers, I think this way is fine. regards, tom lane