How would you write a to_tsquery to find documents containing 'apple' and either 'banana' or 'cherry'?

hard📝 Application Q9 of 15

PostgreSQL - Full-Text Search

How would you write a to_tsquery to find documents containing 'apple' and either 'banana' or 'cherry'?

A'apple & banana | cherry'

B'apple & (banana | cherry)'

C'(apple & banana) | cherry'

D'apple | banana & cherry'

Step-by-Step Solution

Solution:

Step 1: Understand the search logic
We want documents with apple AND (banana OR cherry).
Step 2: Use parentheses to group OR terms
Parentheses around (banana | cherry) ensure correct evaluation order.
Step 3: Evaluate options
'apple & (banana | cherry)' correctly expresses apple & (banana | cherry). Others misplace operators or grouping.
Final Answer:
'apple & (banana | cherry)' -> Option B
Quick Check:
Group OR terms with parentheses for correct logic [OK]

Quick Trick: Group OR terms with parentheses when combined with AND [OK]

Common Mistakes:

Master "Full-Text Search" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free