Function cardinality

fn cardinality<T: TryFrom<usize>>(array: ListRef<'_>) -> Result<T>

Returns the total number of elements in the array.

cardinality ( array anyarray) → int8

Examples:

query T
select cardinality(null::int[]);
----
NULL

query T
select cardinality(array[1,2,3]);
----
3

query T
select cardinality(array[1,2,3,4,1]);
----
5

query T
select cardinality(array[array[1, 2, 3]]);
----
3

query T
select cardinality(array[array[array[3,4,5],array[2,2,2]],array[array[6,7,8],array[0,0,0]]]);
----
12

query T
select cardinality(array[NULL]);
----
1

query error Cannot implicitly cast
select cardinality(null);