migrations/003_fuzzy_search_indexes.sql

Rama main · réplica de lectura del repositorio original.

CREATE EXTENSION IF NOT EXISTS pg_trgm;

CREATE INDEX IF NOT EXISTS idx_documents_lookup_trgm
  ON documents USING GIN (
    lower(regexp_replace(COALESCE(title, '') || ' ' || COALESCE(source_ref, ''), '[^[:alnum:]]+', ' ', 'g'))
    gin_trgm_ops
  );