~vpzom/lotide

ref: 98cc8b10291d36a5c81f1b72e0a557112f1c1647 lotide/migrations/20201026222917_post-fts/up.sql -rw-r--r-- 157 bytes
98cc8b10 — Colin Reeder Merge branch 'post-search' into post-search-integration 1 year, 4 days ago
                                                                                
1
2
3
BEGIN;
	CREATE INDEX post_fts ON post USING gin(to_tsvector('english', title || ' ' || COALESCE(content_text, content_markdown, content_html, '')));
COMMIT;