[Solved] Given the table documents with a column content_tsv of type tsvector, what will this query return?SELECT id FROM documents WHERE content_tsv @@ to_tsquery('cat & dog'); | PostgreSQL

PostgreSQL - Full-Text Search

Given the table documents with a column content_tsv of type tsvector, what will this query return?

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

ARows where content contains both 'cat' and 'dog'

BRows where content contains either 'cat' or 'dog'

CRows where content contains the exact phrase 'cat dog'

DRows where content contains 'cat' but not 'dog'

Step-by-Step Solution

Solution:

Step 1: Understand to_tsquery('cat & dog')
The & operator means AND, so it searches for both words.
Step 2: Apply @@ operator
The query returns rows where content_tsv matches both 'cat' and 'dog'.
Final Answer:
Rows where content contains both 'cat' and 'dog' -> Option A
Quick Check:
AND operator & means both words [OK]

Quick Trick: Use & in tsquery for AND search [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 column content_tsv of type tsvector, what will this query return?