Em dom., 1 de mar. de 2026 às 11:29, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> escreveu:
> I can’t come up with a better header than Partial Mode.
>
The problem is that if they conclude that there is no FILTER for that
aggregate,
they decide to run two queries, not the most readable or the most
performant one.
with Data as (select V from MyTable where F1 = 100)
select (select jsonb_agg(V) from Data) Total,
(select jsonb_agg(V) from MyTable where V>1) Filtered;
regards
Marcos