luda posch <ludaludal...@gmail.com> writes:
> I am not an expert on the official sql spec, but I think it would be useful
> if distinct on() could be used within an aggregate when supplied with
> another column name. For example:
> select sum(distinct on(id) order_price) from order_table;
> select sum(distinct on(email_address) bounce_count) from email_bounces;
> select sum(distinct on(county) area) from state_county_area;
Use another level of sub-select, eg
select sum(order_price) from
(select distinct on(id) order_price from order_table ...) ss;
The usefulness of this doesn't really seem high enough to justify
inventing and maintaining a more compact way to handle it.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
