10 lines
397 B
SQL
10 lines
397 B
SQL
-- Add GIN bigram indexes on project title and description for search.
|
|
DO $$
|
|
BEGIN
|
|
CREATE INDEX idx_project_title_bigm ON project USING gin (LOWER(title) gin_bigm_ops);
|
|
CREATE INDEX idx_project_description_bigm ON project USING gin (LOWER(COALESCE(description, '')) gin_bigm_ops);
|
|
EXCEPTION WHEN OTHERS THEN
|
|
RAISE NOTICE 'skipping bigram indexes on project (pg_bigm not installed)';
|
|
END
|
|
$$;
|