You've already forked pgvecto.rs
mirror of
https://github.com/tensorchord/pgvecto.rs.git
synced 2025-09-13 21:21:48 +03:00
727d69feab
* feat: transactional CREATE/DROP Signed-off-by: usamoi <usamoi@outlook.com> * test: transaction ddl Signed-off-by: usamoi <usamoi@outlook.com> --------- Signed-off-by: usamoi <usamoi@outlook.com>
37 lines
816 B
Plaintext
37 lines
816 B
Plaintext
statement ok
|
|
SET search_path TO pg_temp, vectors;
|
|
|
|
statement ok
|
|
CREATE TABLE t (val vector(3));
|
|
|
|
statement ok
|
|
INSERT INTO t (val) SELECT ARRAY[random(), random(), random()]::real[] FROM generate_series(1, 1000);
|
|
|
|
statement ok
|
|
CREATE INDEX CONCURRENTLY ON t USING vectors (val vector_l2_ops);
|
|
|
|
statement ok
|
|
UPDATE t SET val = ARRAY[0.2, random(), random()]::real[] WHERE val = (SELECT val FROM t ORDER BY val <-> '[0.1,0.1,0.1]' LIMIT 1);
|
|
|
|
statement ok
|
|
INSERT INTO t (val) VALUES ('[0.1,0.1,0.1]');
|
|
|
|
query I
|
|
SELECT val = '[0.1,0.1,0.1]' FROM t ORDER BY val <-> '[0.1,0.1,0.1]' LIMIT 2;
|
|
----
|
|
t
|
|
f
|
|
|
|
statement ok
|
|
REINDEX TABLE CONCURRENTLY t;
|
|
|
|
statement ok
|
|
DELETE FROM t WHERE val = '[0.1,0.1,0.1]';
|
|
|
|
query I
|
|
SELECT val = '[0.1,0.1,0.1]' FROM t ORDER BY val <-> '[0.1,0.1,0.1]' LIMIT 1;
|
|
----
|
|
f
|
|
|
|
statement ok
|
|
DROP TABLE t; |