risingwave_expr_impl::table_function::pg_expandarray

Function _pg_expandarray

Source 
fn _pg_expandarray(
    array: ListRef<'_>,
) -> impl Iterator<Item = (Option<ScalarRefImpl<'_>>, i32)>
Expand description

Returns the input array as a set of rows with an index.

query II
select * from _pg_expandarray(array[1,2,null]);
----
1    1
2    2
NULL 3

query TI
select * from _pg_expandarray(array['one', null, 'three']);
----
one   1
NULL  2
three 3