statement ok SET search_path TO pg_temp, vectors; query I SELECT ('[0, 1, 2, 3, 4, 5, 6, 7]'::vector)[3:6]; ---- [3, 4, 5] query I SELECT ('[0, 1, 2, 3, 4, 5, 6, 7]'::vector)[:4]; ---- [0, 1, 2, 3] query I SELECT ('[0, 1, 2, 3, 4, 5, 6, 7]'::vector)[5:]; ---- [5, 6, 7] query I SELECT ('[0, 1, 2, 3, 4, 5, 6, 7]'::vector)[1:8]; ---- [1, 2, 3, 4, 5, 6, 7] statement error type vector does only support one subscript SELECT ('[0, 1, 2, 3, 4, 5, 6, 7]'::vector)[3:3][1:1]; statement error type vector does only support slice fetch SELECT ('[0, 1, 2, 3, 4, 5, 6, 7]'::vector)[3]; query I SELECT ('[0, 1, 2, 3, 4, 5, 6, 7]'::vector)[5:4]; ---- NULL query I SELECT ('[0, 1, 2, 3, 4, 5, 6, 7]'::vector)[9:]; ---- NULL query I SELECT ('[0, 1, 2, 3, 4, 5, 6, 7]'::vector)[:0]; ---- NULL query I SELECT ('[0, 1, 2, 3, 4, 5, 6, 7]'::vector)[:-1]; ---- NULL query I SELECT ('[0, 1, 2, 3, 4, 5, 6, 7]'::vector)[NULL:NULL]; ---- NULL query I SELECT ('[0, 1, 2, 3, 4, 5, 6, 7]'::vector)[NULL:8]; ---- NULL query I SELECT ('[0, 1, 2, 3, 4, 5, 6, 7]'::vector)[1:NULL]; ---- NULL query I SELECT ('[0, 1, 2, 3, 4, 5, 6, 7]'::vector)[NULL:]; ---- NULL query I SELECT ('[0, 1, 2, 3, 4, 5, 6, 7]'::vector)[:NULL]; ---- NULL