Re: BUG #18525: Boolean aggregate functions like EVERY/BOOL_AND should shortcut

PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> I was hoping that the EVERY aggregate functions would
> _shortcut_ the aggregate as soon as a non-null value was encountered, and
> furthermore that the SELECT statement would stop searching once all results
> are established to be false.

Don't hold your breath. That would require poking a lot of holes in
our abstract API for aggregate functions, and the potential return
seems rather, um, specialized.

You can get an efficient plan for what you want along the lines of

select
exists(select * from large_table where field1 is not null),
exists(select * from large_table where field2 is not null),
...

This will result in a scan per EXISTS() rather than just one scan,
but on the other hand the scans will be smart enough to use indexes
where helpful. In any case they will stop at first match.

regards, tom lane