On 5 August 2010 10:29, Greg Stark <[email protected]> wrote: > On Thu, Aug 5, 2010 at 5:18 AM, Pavel Stehule <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
