[Solved] Given the table articles with column body, what will this query return?SELECT title, ts_rank(to_tsvector(body), to_tsquery('postgres')) AS rank FROM articles ORDER BY rank DESC LIMIT 3; | PostgreSQL

PostgreSQL - Full-Text Search

Given the table articles with column body, what will this query return?

SELECT title, ts_rank(to_tsvector(body), to_tsquery('postgres')) AS rank FROM articles ORDER BY rank DESC LIMIT 3;

A3 articles with the shortest body length

BAll articles sorted alphabetically by title

CTop 3 articles ranked by relevance to 'postgres'

D3 random articles from the table

Step-by-Step Solution

Solution:

Step 1: Analyze the query components
The query calculates a rank using ts_rank for each article's body against the search term 'postgres'.
Step 2: Understand ORDER BY and LIMIT
Results are ordered by rank descending, limiting output to top 3 most relevant articles.
Final Answer:
Top 3 articles ranked by relevance to 'postgres' -> Option C
Quick Check:
Query result = Top 3 relevant articles [OK]

Quick Trick: ORDER BY rank DESC LIMIT gets top matches [OK]

Common Mistakes:

Master "Full-Text Search" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Given the table articles with column body, what will this query return?