Hi út 10. 3. 2026 v 20:58 odesílatel Juan Rodrigo Alejandro Burgos Mella < [email protected]> napsal:
> To do something similar, you would have to fork the source code and > implement the declarations with the same syntax, resulting in something > like Postracle. > orafce has listagg function https://github.com/orafce/orafce Regards Pavel > > Atte > JRBM > > El mar, 10 mar 2026 a las 13:53, Pierre Forstmann (< > [email protected]>) escribió: > >> I agree but I just would like to know if there is way to be compatible >> with Oracle syntax using aggregate features in PostgreSQL >> >> Thanks. >> >> Le 09/03/2026 à 23:05, Paul A Jungwirth a écrit : >> > On Mon, Mar 9, 2026 at 1:21 PM Pierre Forstmann >> > <[email protected]> wrote: >> >> Hello, >> >> >> >> I can write a LISTAGG aggregate for: >> >> >> >> create table emp(deptno numeric, ename text); >> >> >> >> SELECT deptno, LISTAGG(ename, ','::text ORDER BY ename) AS employees >> >> FROM emp GROUP BY deptno ORDER BY deptno; >> >> >> >> I would like to know if is possible to create an aggregate LISTAGG that >> >> would work like in Oracle: >> >> >> >> SELECT deptno, >> >> listagg(ename, ',') WITHIN GROUP (ORDER BY ename) AS employees >> >> FROM emp >> >> GROUP BY deptno >> >> ORDER BY deptno; >> > I don't think you need a custom aggregate here. In Postgres you can say: >> > >> > select deptno, >> > string_agg(ename, ',' ORDER BY ename) AS employees >> > FROM emp >> > GROUP BY deptno >> > ORDER BY deptno; >> > >> >> >>
