You want to rank documents by relevance but give higher weight to matches in the title than in the body. Which ts_rank usage achieves this?

hard📝 Application Q8 of 15

PostgreSQL - Full-Text Search

You want to rank documents by relevance but give higher weight to matches in the title than in the body. Which ts_rank usage achieves this?

Ats_rank(to_tsvector(title) + to_tsvector(body), to_tsquery('search'))

Bts_rank(setweight(to_tsvector(title), 'A') || setweight(to_tsvector(body), 'B'), to_tsquery('search'))

Cts_rank(to_tsvector(body), to_tsquery('search'))

Dts_rank(to_tsquery('search'), to_tsvector(title || body))

Step-by-Step Solution

Solution:

Step 1: Understand weighting with setweight
Use setweight to assign higher priority ('A') to title and lower ('B') to body.
Step 2: Combine weighted vectors and apply ts_rank
Concatenate weighted tsvectors and rank against query.
Final Answer:
ts_rank(setweight(to_tsvector(title), 'A') || setweight(to_tsvector(body), 'B'), to_tsquery('search')) -> Option B
Quick Check:
Weighted vectors + ts_rank = Correct ranking [OK]

Quick Trick: Use setweight to prioritize fields in ts_rank [OK]

Common Mistakes:

Master "Full-Text Search" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free