fn trim_array(array: ListRef<'_>, n: i32) -> Result<ListValue>Expand description
Trims an array by removing the last n elements. If the array is multidimensional, only the first dimension is trimmed.
Examples:
query T
select trim_array(array[1,2,3,4,5,null], 4);
----
{1,2}
query T
select trim_array(array[1,2,3,4,5,null], 0);
----
{1,2,3,4,5,NULL}
query T
select trim_array(array[1,2,3,4,5,null], null);
----
NULL
query T
select trim_array(array[1,2,3,4,5,null], null::smallint);
----
NULL
query T
select trim_array(array[1,2,3,4,5,null], 6);
----
{}
query T
select trim_array(null::int[], 1);
----
NULL
statement error
select trim_array(array[1,2,3,4,5,null], 7);
statement error
select trim_array(array[1,2,3,4,5,null], -1);
statement error
select trim_array(array[1,2,3,4,5,null], null::bigint);
statement error
select trim_array(array[1,2,3,4,5,null], 3.14);
statement error
select trim_array(array[1,2,3,4,5,null], array[1]);
statement error
select trim_array(array[1,2,3,4,5,null], true);