Re: Conditional return of aggregated data

On Mon, 2 Dec 2019 at 12:11, Laura Smith <[email protected]>
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.