> 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. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
