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? -- 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
