mirror of
https://github.com/multica-ai/multica.git
synced 2026-07-23 10:08:38 +02:00
75e8bd5b64
Co-authored-by: Eve <eve@multica-ai.local> Co-authored-by: multica-agent <github@multica.ai>
6 lines
308 B
SQL
6 lines
308 B
SQL
-- Fallback GIN index for SearchProjects description LIKE matches when pg_bigm
|
|
-- is not available. Single-statement file required for CREATE INDEX
|
|
-- CONCURRENTLY.
|
|
CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_project_description_trgm
|
|
ON project USING gin (LOWER(COALESCE(description, '')) gin_trgm_ops);
|