Re: Partial Mode in Aggregate Functions

From: Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: David Rowley <dgrowleyml(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Partial Mode in Aggregate Functions
Date: 2026-03-01 15:00:09
Message-ID: CAB-JLwZaLpS26_iwY=GQ8wh7bTvW4atNQez3neeicV3u7AZ0=Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Em dom., 1 de mar. de 2026 às 11:54, Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
escreveu:

> with Data as (select V from MyTable where F1 = 100)
> select (select jsonb_agg(V) from Data) Total,
> (select jsonb_agg(V) from Data where V>1) Filtered;
>
This one should be.
Regards
Marcos

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2026-03-01 15:03:36 Re: index prefetching
Previous Message Marcos Pegoraro 2026-03-01 14:54:27 Re: Partial Mode in Aggregate Functions