[Solved] What will be the result of:SELECT to_tsvector('english', 'Cats and dogs') @@ to_tsquery('english', 'cat | dog'); | PostgreSQL

PostgreSQL - Full-Text Search

What will be the result of:
SELECT to_tsvector('english', 'Cats and dogs') @@ to_tsquery('english', 'cat | dog');

Afalse

Btrue

CSyntax error

DNULL

Step-by-Step Solution

Solution:

Step 1: Analyze the tsvector and tsquery
to_tsvector converts 'Cats and dogs' to tokens 'cat' and 'dog' (stemmed). The to_tsquery searches for 'cat' OR 'dog'.
Step 2: Evaluate the OR condition
Since both 'cat' and 'dog' appear, the OR condition is true.
Final Answer:
true -> Option B
Quick Check:
OR in tsquery returns true if any token matches [OK]

Quick Trick: Use | for OR in tsquery expressions [OK]

Common Mistakes:

Master "Full-Text Search" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What will be the result of: