vetrag/migrations/0007_add_dual_embedding_col...

11 lines
379 B
SQL

-- +goose Up
-- Add separate columns for different embedding dimensions using standard Postgres FLOAT[] arrays
ALTER TABLE sentence_embeddings
ADD COLUMN IF NOT EXISTS embedding_384 FLOAT[],
ADD COLUMN IF NOT EXISTS embedding_1536 FLOAT[];
-- +goose Down
ALTER TABLE sentence_embeddings
DROP COLUMN IF EXISTS embedding_384,
DROP COLUMN IF EXISTS embedding_1536;