You've already forked pgvecto.rs
mirror of
https://github.com/tensorchord/pgvecto.rs.git
synced 2025-08-01 06:46:52 +03:00
74 lines
1.2 KiB
Plaintext
74 lines
1.2 KiB
Plaintext
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
|