> I know it's heresy in these parts, but maybe we should consider
> adopting a non-spec syntax for this feature? In particular, it's
> really un-obvious why the FILTER clause shouldn't be inside rather
> than outside the aggregate's parens, like ORDER BY.
Well, what other DBMSes support this feature? Will being non-spec
introduce migration pain?
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com