ALL_MATCH

Returns TRUE if all elements in an array match the given predicate.

Analyze Syntax

func.all_match(get_column(table, 'arr'), lambda x: x > 0)

Analyze Examples

func.all_match([1, 2, 3], lambda x: x > 0)

┌───┐
 1 
└───┘

SQL Syntax

ALL_MATCH(<arr>, lambda x: x > 0)

SQL Examples

SELECT ALL_MATCH([1, 2, 3], x -> x > 0);

┌───┐
 1 
└───┘