diff options
| -rw-r--r-- | migrations/2018-04-14-170750_search-index/up.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/migrations/2018-04-14-170750_search-index/up.sql b/migrations/2018-04-14-170750_search-index/up.sql index ed997d3e041b..6b7d90eca63c 100644 --- a/migrations/2018-04-14-170750_search-index/up.sql +++ b/migrations/2018-04-14-170750_search-index/up.sql @@ -10,8 +10,8 @@ CREATE MATERIALIZED VIEW search_index AS t.id AS thread_id, t.title AS title, p.body AS body, - setweight(to_tsvector('english', t.title), 'A') || - setweight(to_tsvector('english', p.body), 'B') || + setweight(to_tsvector('english', t.title), 'B') || + setweight(to_tsvector('english', p.body), 'A') || setweight(to_tsvector('simple', t.author_name), 'C') || setweight(to_tsvector('simple', p.author_name), 'C') AS document FROM posts p |