2010/1/29 Alvaro Herrera <alvhe...@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. > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers