>> No, there needs to be a way for the individual window function to >> throw error if that's specified for a function that can't handle it. >> I'm just saying I don't want that to be hard-wired in some centralized >> spot. > > Would it be acceptable to add a bool column to pg_proc, say > "pronulltreatment"? It would default to false, and an error would be > thrown if the null clause is specified for a function where it's set > to false?
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. Best reagards, -- Tatsuo Ishii SRA OSS K.K. English: http://www.sraoss.co.jp/index_en/ Japanese:http://www.sraoss.co.jp
