On 5 August 2010 10:29, Greg Stark <gsst...@mit.edu> wrote: > On Thu, Aug 5, 2010 at 5:18 AM, Pavel Stehule <pavel.steh...@gmail.com> wrote: >> The same problem can be with custom aggregates :( so this syntax isn't >> too robust. We can support Oracle's syntax in future releases, where >> syntax divide aggregate call and ORDER BY clause. >> > > What syntax is that? > > -- > greg >
An example I've found is: SELECT deptno, LISTAGG(ename, ',') WITHIN GROUP (ORDER BY ename) AS employees FROM emp GROUP BY deptno; -- Thom Brown Registered Linux user: #516935 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
