LISTAGG à la Oracle in PostgreSQL
| От | Pierre Forstmann |
|---|---|
| Тема | LISTAGG à la Oracle in PostgreSQL |
| Дата | |
| Msg-id | de6c5d45-7ce9-42bd-9528-97fdf4ffa0e4@gmail.com обсуждение исходный текст |
| Ответы |
Re: LISTAGG à la Oracle in PostgreSQL
Re: LISTAGG à la Oracle in PostgreSQL Re: LISTAGG à la Oracle in PostgreSQL |
| Список | pgsql-general |
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 failed and IA also failed. Claude says: It is not possible to exactly replicate listagg(ename, ',') WITHIN GROUP (ORDER BY ename) as a custom PostgreSQL aggregate because PostgreSQL strictly forbids ungrouped columns as direct arguments to ordered-set aggregates. Do you agree ?
В списке pgsql-general по дате отправления: