Re: Conditional return of aggregated data

[Alban Hertroys <haramrae@xxxxxxxxx>]

On Mon, 2 Dec 2019 at 12:11, Laura Smith <n5d9xq3ti233xiyif2vp@xxxxxxxxxxxxx> wrote:

My initial idea was something along the lines of :
 select (select sum(statcount) from stats_residence) as aggstat,statcount,short_name_en from stats_residence where aggstat>some_number;

 

One option is to move the aggregate to the where-clause. If you also need the value in your select-list, you can just repeat the subselect there, usually the planner is smart enough to figure out that it can just re-use the result.

select short_name_en from stats_residence where (select sum(statcount) from stats_residence) >some_number;

--

If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.