BOOLEAN_AND_AGG

Syntax

Description of the illustration boolean_and_agg.eps

Purpose

BOOLEAN_AND_AGG returns 'TRUE' if the boolean_expr evaluates to true for every 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_AND_AGG(c2)
    FROM t;

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

SELECT BOOLEAN_AND_AGG(c2)
    FROM t
    WHERE c2 IS FALSE;

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

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

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

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