2010/1/29 Alvaro Herrera <alvherre@commandprompt.com>:
> Jonah H. Harris escribió:
>
>> The syntax is listagg(expression [, delimiter]) WITHIN GROUP (order by
>> clause) [OVER partition clause]
>> If a delimiter is defined, it must be a constant.
>>
>> Query: SELECT listagg(a, ',') WITHIN GROUP (ORDER BY a) FROM foo;
>> Result: aaa,bbb,ccc
>
> So that's how Oracle supports ordered aggregates? Interesting -- we
> just got that capability but using a different syntax. Hmm, the
> SQL:200x draft also has <within group specification> which seems the
> standard way to do the ORDER BY stuff for aggregates ... Should we
> change the syntax?
Oracle syntax is little bit longer, but it is safer. What is a standard?
Regards
Pavel Stehule
p.s. if it is only syntactic suger, then can't be a problem.
Pavel
>
> --
> Alvaro Herrera http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>