risingwave_expr_impl::scalar::array_length

Function array_length

Source 
fn array_length<T: TryFrom<usize>>(array: ListRef<'_>) -> Result<T>
Expand description

Returns the length of an array.

array_length (array anyarray) → int8

Examples:

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

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

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

query T
select array_length(array[]::int[]);
----
0

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

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

query error Cannot implicitly cast
select array_length(null);