risingwave_expr_impl::table_function::generate_subscripts

Function generate_subscripts_reverse

Source 
fn generate_subscripts_reverse(
    array: ListRef<'_>,
    dim: i32,
    reverse: bool,
) -> impl Iterator<Item = i32>
Expand description
query I
SELECT generate_subscripts(ARRAY['foo', 'bar', null], -1, false) AS s;
----

query I
SELECT generate_subscripts(ARRAY['foo', 'bar', null], 0, false) AS s;
----

query I
SELECT generate_subscripts(ARRAY['foo', 'bar', null], 1, true) AS s;
----
3
2
1

query I
SELECT generate_subscripts(ARRAY['foo', 'bar', null], 1, false) AS s;
----
1
2
3

query I
SELECT generate_subscripts(ARRAY[ARRAY['foo'], ARRAY['bar'], ARRAY[null]], 0, false) AS s;
----

query I
SELECT generate_subscripts(ARRAY[ARRAY['foo'], ARRAY['bar'], ARRAY[null]], 1, false) AS s;
----
1
2
3

query I
SELECT generate_subscripts(ARRAY[ARRAY['foo'], ARRAY['bar'], ARRAY[null]], 2, false) AS s;
----
1