Message-ID: <f73eca88-0396-44b6-b476-f6a288eac435@gmail.com>
Date: Wed, 11 Mar 2026 16:53:52 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
From: pierre.forstmann@gmail.com
To: Pavel Stehule <pavel.stehule@gmail.com>,
 Juan Rodrigo Alejandro Burgos Mella <rodrigoburgosmella@gmail.com>,
 Paul A Jungwirth <pj@illuminatedcomputing.com>,
 "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: =?UTF-8?Q?Re=3A_LISTAGG_=C3=A0_la_Oracle_in_PostgreSQL?=
References: <de6c5d45-7ce9-42bd-9528-97fdf4ffa0e4@gmail.com>
 <CA+renyUW6+JUM5d6OJ8XZR3araY2iii5xTYP5kSUjqgLdY+uSg@mail.gmail.com>
 <c5b36c72-ae87-4623-85a5-b487090923b4@gmail.com>
 <CAHbZ42zA=VUCTWMjusbjdSemuTtKhmg-HzTGnB8n7A0ps_ebEg@mail.gmail.com>
 <CAFj8pRCz5eqmtWhbqC-iY9x-97WMTgDRN7syw9q9aeuSqzpTqQ@mail.gmail.com>
 <CAFj8pRB-GUcyjBEOLKoHUcmkR7TWjmfEJk-9gAKYs7o_uhYyuw@mail.gmail.com>
In-Reply-To: <CAFj8pRB-GUcyjBEOLKoHUcmkR7TWjmfEJk-9gAKYs7o_uhYyuw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/f73eca88-0396-44b6-b476-f6a288eac435%40gmail.com>
Precedence: bulk

Thanks.

On 10/03/2026 22:46, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> 
> 
> út 10. 3. 2026 v 21:23 odesílatel Pavel Stehule <pavel.stehule@gmail.com 
> <mailto:pavel.stehule@gmail.com>> napsal:
> 
>     Hi
> 
>     út 10. 3. 2026 v 20:58 odesílatel Juan Rodrigo Alejandro Burgos
>     Mella <rodrigoburgosmella@gmail.com
>     <mailto:rodrigoburgosmella@gmail.com>> 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
>     <https://github.com/orafce/orafce>
> 
> 
> but it doesn't support syntax WITHING GROUP syntax. Probably there is 
> not a possibility to implement it in extension without introducing a new 
> kind of aggregate functions in core, or enhancing behaviour of ordered- 
> set kind of aggregates.
> 
> Regards
> 
> Pavel
> 
> 
> 
> 
> 
>     Regards
> 
>     Pavel
> 
> 
>         Atte
>         JRBM
> 
>         El mar, 10 mar 2026 a las 13:53, Pierre Forstmann
>         (<pierre.forstmann@gmail.com
>         <mailto:pierre.forstmann@gmail.com>>) 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
>              > <pierre.forstmann@gmail.com
>             <mailto:pierre.forstmann@gmail.com>> 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;
>              >
> 
> 
>