[Solved] Given the table documents with a GIN index on to_tsvector('english', text), what will the query below return?SELECT id FROM documents WHERE to_tsvector('english', text) @@ to_tsquery('quick & fox'); | PostgreSQL

PostgreSQL - Full-Text Search

Given the table documents with a GIN index on to_tsvector('english', text), what will the query below return?

SELECT id FROM documents WHERE to_tsvector('english', text) @@ to_tsquery('quick & fox');

AAll document IDs containing the exact phrase 'quick fox'

BAll document IDs containing either 'quick' or 'fox'

CAll document IDs containing both words 'quick' and 'fox'

DSyntax error due to incorrect query

Step-by-Step Solution

Solution:

Step 1: Understand to_tsquery with '&'
The '&' operator means AND, so the query looks for documents containing both 'quick' and 'fox'.
Step 2: Match with @@ operator
The @@ operator checks if the tsvector matches the tsquery condition, returning matching document IDs.
Final Answer:
All document IDs containing both words 'quick' and 'fox' -> Option C
Quick Check:
to_tsquery('quick & fox') = AND search [OK]

Quick Trick: Use '&' in to_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 GIN index on to_tsvector('english', text), what will the query below return?