query R
SELECT subvector('[1,2,3,4,5]'::vector(5), 1, 3);
----
[1,2,3]
query R
SELECT subvector('[1,2,3,4,5]'::vector(5), 3, 2);
----
[3,4]
query R
SELECT subvector('[1,2,3,4,5]'::vector(5), 1, 5);
----
[1,2,3,4,5]
query R
SELECT subvector('[1,2,3,4,5]'::vector(5), 5, 1);
----
[5]
query R
SELECT subvector('[1,2,3,4,5]'::vector(5), 2, 3);
----
[2,3,4]
query R
select subvector(vec, 1, 3) from (values ('[1,2,3,4,5]'::vector(5)), ('[6,7,8,9,10]'::vector(5))) as t(vec);
----
[1,2,3]
[6,7,8]
statement error
SELECT subvector('[1,2,3,4,5]'::vector(5), -1, 2);
statement error
SELECT subvector('[6,7,8,9,10]'::vector(5), 1, 6);
statement error
SELECT subvector('[6,7,8,9,10]'::vector(5), 5, 2);