PGvector

作者: 何亮hook_8285 | 来源:发表于2023-12-30 22:05 被阅读0次
    #sql语句
    select * from (SELECT id,features,1 - (features <-> ?) as similarity FROM items ORDER BY features <-> ? LIMIT 5) as faces where faces.similarity between 0.8 and 1.0 
    
    #jdbc
     <dependency>
                <groupId>com.pgvector</groupId>
                <artifactId>pgvector</artifactId>
                <version>0.1.3</version>
            </dependency>
            <dependency>
                <groupId>cn.hutool</groupId>
                <artifactId>hutool-all</artifactId>
                <version>5.8.16</version>
            </dependency>
    

    相关文章

      网友评论

          本文标题:PGvector

          本文链接:https://www.haomeiwen.com/subject/incxbdtx.html