duckplus.functions.aggregate.boolean

Boolean aggregate helpers exposed as direct Python functions.

Functions

bool_and(...)	Call DuckDB function bool_and.
bool_and_filter(...)	Call DuckDB function bool_and with FILTER.
bool_or(...)	Call DuckDB function bool_or.
bool_or_filter(...)	Call DuckDB function bool_or with FILTER.

Module Contents

duckplus.functions.aggregate.boolean.bool_and(self: duckplus.static_typed._generated_function_namespaces.AggregateBooleanFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.BooleanExpression

Call DuckDB function bool_and.

Returns TRUE if every input value is TRUE, otherwise FALSE.

Overloads: - main.bool_and(BOOLEAN arg) -> BOOLEAN

duckplus.functions.aggregate.boolean.bool_and_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateBooleanFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.BooleanExpression

Call DuckDB function bool_and with FILTER.

Returns TRUE if every input value is TRUE, otherwise FALSE.

Overloads: - main.bool_and(BOOLEAN arg) -> BOOLEAN

duckplus.functions.aggregate.boolean.bool_or(self: duckplus.static_typed._generated_function_namespaces.AggregateBooleanFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.BooleanExpression

Call DuckDB function bool_or.

Returns TRUE if any input value is TRUE, otherwise FALSE.

Overloads: - main.bool_or(BOOLEAN arg) -> BOOLEAN

duckplus.functions.aggregate.boolean.bool_or_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateBooleanFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.BooleanExpression

Call DuckDB function bool_or with FILTER.

Returns TRUE if any input value is TRUE, otherwise FALSE.

Overloads: - main.bool_or(BOOLEAN arg) -> BOOLEAN