Hello. I've noticed the following in v11 release notes: "Window functions now support all options shown in the SQL:2011 standard, including RANGE distance PRECEDING/FOLLOWING, GROUPS mode, and frame exclusion options"
But, as far as I see, IGNORE NULLS option for lead, lag, etc. is still not supported. May be, the item could be reformulated? -- WBR, Yaroslav Schekin ----- WBR, Yaroslav Schekin. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html