BOOLEAN_OR_AGG

Syntax

Description of the illustration boolean_or_agg.eps

Purpose

BOOLEAN_OR_AGG returns 'TRUE' if the boolean_expr evaluates to true for at least one row that qualifies. Otherwise it returns 'FALSE'. You can use it as an aggregate or analytic function.

For the semantics of the FILTER clause, see FILTER Clause Semantics.

Examples

SELECT BOOLEAN_OR_AGG(c2)
    FROM t; 
    

SELECT BOOLEAN_OR_AGG(c2)
    FROM t
    WHERE c1 = 0;

SELECT BOOLEAN_OR_AGG(c2)
    FROM t
    WHERE c2 IS TRUE;

SELECT BOOLEAN_OR_AGG(c2)
    FROM t
    WHERE c2 IS TRUE OR c2 IS NULL;

SELECT BOOLEAN_OR_AGG(c2)
    FROM t
    WHERE c2 IS NOT FALSE OR c2 IS NULL;

SELECT BOOLEAN_OR_AGG(c2)
    FROM t
    WHERE c2 IS NOT TRUE OR c2 IS NULL;

SELECT BOOLEAN_OR_AGG(c2 OR c2)
    FROM t
    WHERE c2 IS NOT TRUE OR c2 IS NULL;