ALL_MATCH
Learn how to use the ALL_MATCH array function in PlaidCloud Lakehouse. Returns TRUE if all elements in an array match the given predicate.
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 │
└───┘