Postgres Pro
Downloads
Home   >   mailing lists

Re: FILTER for aggregates [was Re: Department of Redundancy Department: makeNode(FuncCall) division] - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: FILTER for aggregates [was Re: Department of Redundancy Department: makeNode(FuncCall) division]
Date
Msg-id 51CA2F63.9060901@agliodbs.com
Whole thread Raw
In response to Re: FILTER for aggregates [was Re: Department of Redundancy Department: makeNode(FuncCall) division]  (David Fetter <david@fetter.org>)
Responses Re: FILTER for aggregates [was Re: Department of Redundancy Department: makeNode(FuncCall) division]
List pgsql-hackers
Tree view 
> 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

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Possible bug in CASE evaluation
Next
From: Josh Berkus
Date:
Subject: Re: Review: UNNEST (and other functions) WITH ORDINALITY