[Solved] Given the table documents with a text_content column, what will this query return?SELECT id FROM documents WHERE text_content @@ to_tsquery('cat & dog');Assuming the table has these rows:1:... | PostgreSQL

PostgreSQL - Full-Text Search

Given the table documents with a text_content column, what will this query return?

SELECT id FROM documents WHERE text_content @@ to_tsquery('cat & dog');

Assuming the table has these rows:

A[]

B[1, 2]

C[3]

D[1, 2, 3]

Step-by-Step Solution

Solution:

Step 1: Understand the query condition
The query uses to_tsquery('cat & dog'), which means both 'cat' AND 'dog' must be present in text_content.
Step 2: Check each row for both words
Row 1 has 'cat' and 'dog'. Row 2 has both words as well. Row 3 only has 'cat', missing 'dog'.
Final Answer:
[1, 2] -> Option B
Quick Check:
AND search returns rows with both terms [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 documents with a text_content column, what will this query return?