[Solved] Find the mistake in this query:SELECT ts_rank(to_tsvector(body), to_tsquery('english', 'data & science')) AS rank FROM articles WHERE rank > 0.5; | PostgreSQL

PostgreSQL - Full-Text Search

Find the mistake in this query:

SELECT ts_rank(to_tsvector(body), to_tsquery('english', 'data & science')) AS rank FROM articles WHERE rank > 0.5;

Ato_tsquery requires no language parameter

Bto_tsvector should be replaced with plainto_tsquery

CCannot use alias 'rank' in WHERE clause directly

DMissing GROUP BY clause

Step-by-Step Solution

Solution:

Step 1: Check alias usage in WHERE clause
Aliases like 'rank' cannot be referenced in WHERE; use subquery or HAVING.
Step 2: Validate other parts
Language parameter in to_tsquery is valid; no GROUP BY needed here.
Final Answer:
Cannot use alias 'rank' in WHERE clause directly -> Option C
Quick Check:
Alias in WHERE = Not allowed [OK]

Quick Trick: Filter on alias using subquery or HAVING [OK]

Common Mistakes:

Master "Full-Text Search" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Find the mistake in this query: