[Solved] Given the table articles with a column content, what will this query return?SELECT id FROM articles WHERE to_tsvector('english', content) @@ to_tsquery('english', 'database & search'); | PostgreSQL

PostgreSQL - Full-Text Search

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

SELECT id FROM articles WHERE to_tsvector('english', content) @@ to_tsquery('english', 'database & search');

ASyntax error due to incorrect query.

BAll article IDs where content contains either 'database' or 'search'.

CAll article IDs where content contains the exact phrase 'database search'.

DAll article IDs where content contains both 'database' and 'search'.

Step-by-Step Solution

Solution:

Step 1: Understand the @@ operator
The @@ operator checks if the text vector matches the text query.
Step 2: Interpret the query string 'database & search'
The '&' means AND, so both words must be present in the content.
Final Answer:
All article IDs where content contains both 'database' and 'search'. -> Option D
Quick Check:
'&' means AND in to_tsquery [OK]

Quick Trick: Use '&' in to_tsquery for AND condition [OK]

Common Mistakes:

Master "Full-Text Search" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

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