vshmidt/pgvector: Open-source vector similarity search for Postgres

test/sql/btree.sql

12 строк325 B

Andrew Kane

Moved sql and test files

06 май 2021, 01:04

06 май 2021, 01:04baabbae

SET client_min_messages = warning;
CREATE EXTENSION IF NOT EXISTS vector;
SET enable_seqscan = off;

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]';
SELECT * FROM t ORDER BY val LIMIT 1;

DROP TABLE t;