2010/2/1 Tom Lane <[email protected]>: > Hitoshi Harada <[email protected]> writes: >> In other words, the queries can be the same: > >> SELECT array_agg(val ORDER BY sk) FROM ... >> SELECT array_agg(val) WITHIN GROUP (ORDER BY sk) FROM ... > > One more time: THOSE DON'T MEAN THE SAME THING. If we ever get > around to implementing the hypothetical set functions, we would > be very unhappy to have introduced such a bogus equivalence.
I completely agree. Although Oracle's syntax can express ordered aggregate, by introducing such syntax now it will be quite complicated to implement hypothetical functions for those syntactic restrictions and design in the future. Regards, -- Hitoshi Harada -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
