Re: Aggregate ORDER BY patch - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Aggregate ORDER BY patch
Date
Msg-id 4AFD10B7.1090902@enterprisedb.com
Whole thread Raw
In response to Aggregate ORDER BY patch  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Responses Re: Aggregate ORDER BY patch
Re: Aggregate ORDER BY patch
Re: Aggregate ORDER BY patch
List pgsql-hackers
Andrew Gierth wrote:
> Herewith a patch to implement agg(foo ORDER BY bar) with or without
> DISTINCT, etc.

What does that mean? Aggregate functions are supposed to be commutative,
right?

> No artificial restrictions are imposed on what
> syntactical combinations are allowed. However, ORDER BY is not allowed
> with aggregates used as window functions (as per the existing
> restriction on DISTINCT).

How is this different from window functions?

--  Heikki Linnakangas EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: daveg
Date:
Subject: Re: EOL for 7.4?
Next
From: David Fetter
Date:
Subject: IS DISTINCT FROM vs. ANY