Golfn/Agent_Course_Eval
0
Script to setting up tables and vector search "CREATE EXTENSION IF NOT EXISTS vector;" """ CREATE TABLE IF NOT EXISTS documents2 ( id BIGINT PRIMARY KEY, content TEXT, metadata JSONB, embedding VECTOR(1536) ); """
create or replace function matchdocuments2( queryembedding vector(1536), matchcount int default 5 ) returns table ( id bigint, content text, metadata jsonb, embedding vector ) language sql as $$ select id, content, metadata, embedding from documents2 order by embedding <#> queryembedding limit matchcount; $$;
