1、创建插件
CREATE EXTENSION vector;
2、指定插件的路径(数据库)
set search_path = "xxx";
3、写入测试数据,并进行测试
CREATE TABLE items (id bigserial PRIMARY KEY, embedding vector(3));
INSERT INTO items (embedding) VALUES ('[1,2,3]'), ('[4,5,6]');
SELECT *,a.embedding <=> b.embedding as distance -- 余弦距离
,a.embedding <-> b.embedding as distance -- 欧式距离
FROM items as a cross join items as b;
引用: