/
vshmidt
/
pgvector
Обзор
Документация
Войти
/
vshmidt
/
pgvector
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
test/expected/btree.out
61 строка
1 KB
Andrew Kane
Condensed regression tests [skip ci]
26 апр 2024, 01:30
26 апр 2024, 01:30
68ac05e
Код
Авторство
О чём код?
SET enable_seqscan = off; -- vector CREATE TABLE t (val vector(3)); INSERT INTO t (val) VALUES ('[0,0,0]'), ('[1,2,3]'), ('[1,1,1]'), (NULL); CREATE INDEX ON t (val); SELECT * FROM t WHERE val = '[1,2,3]'; val --------- [1,2,3] (1 row) SELECT * FROM t ORDER BY val; val --------- [0,0,0] [1,1,1] [1,2,3] (4 rows) DROP TABLE t; -- halfvec CREATE TABLE t (val halfvec(3)); INSERT INTO t (val) VALUES ('[0,0,0]'), ('[1,2,3]'), ('[1,1,1]'), (NULL); CREATE INDEX ON t (val); SELECT * FROM t WHERE val = '[1,2,3]'; val --------- [1,2,3] (1 row) SELECT * FROM t ORDER BY val; val --------- [0,0,0] [1,1,1] [1,2,3] (4 rows) DROP TABLE t; -- sparsevec CREATE TABLE t (val sparsevec(3)); INSERT INTO t (val) VALUES ('{}/3'), ('{1:1,2:2,3:3}/3'), ('{1:1,2:1,3:1}/3'), (NULL); CREATE INDEX ON t (val); SELECT * FROM t WHERE val = '{1:1,2:2,3:3}/3'; val ----------------- {1:1,2:2,3:3}/3 (1 row) SELECT * FROM t ORDER BY val; val ----------------- {}/3 {1:1,2:1,3:1}/3 {1:1,2:2,3:3}/3 (4 rows) DROP TABLE t;