You want to find documents containing either 'apple' or 'orange' but not 'banana'. Which to_tsquery expression correctly represents this?

hard📝 Application Q8 of 15

PostgreSQL - Full-Text Search

A'apple | orange & banana'

B'apple & orange | !banana'

C'apple & (orange | !banana)'

D'(apple | orange) & !banana'

Step-by-Step Solution

Solution:

Step 1: Understand to_tsquery operators
'|' means OR, '&' means AND, '!' means NOT.
Step 2: Build the correct expression
We want (apple OR orange) AND NOT banana, which is '(apple | orange) & !banana'.
Final Answer:
'(apple | orange) & !banana' -> Option D
Quick Check:
Correct boolean logic in to_tsquery = C [OK]

Quick Trick: Use | for OR, & for AND, ! for NOT in to_tsquery [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