> My interpretation of the standard is that FILTER is not allowable for
> a window function, and IGNORE|RESPECT NULLS is not allowable for an
> ordinary aggregate.
Yes, it is clear.
> So if we support IGNORE|RESPECT NULLS for anything other than a window
> function, we have to come up with our own semantics.
I don't think this clause is useful for aggregates especially while we
already have the FILTER clause. Though, I can see this error message
being useful:
> ERROR: IGNORE NULLS is only implemented for the lead and lag window functions
Can we still give this message when the syntax is not part of the OVER clause?
Thank you for returning back to this patch.