How can you modify this query to find rows where description contains either 'apple' or 'orange' but not 'banana' using the @@ operator?

hard📝 Application Q9 of 15

PostgreSQL - Full-Text Search

How can you modify this query to find rows where description contains either 'apple' or 'orange' but not 'banana' using the @@ operator?

SELECT * FROM products WHERE to_tsvector(description) @@ to_tsquery('apple | orange');

ASELECT * FROM products WHERE to_tsvector(description) @@ to_tsquery('(apple | orange) & !banana');

BSELECT * FROM products WHERE to_tsvector(description) @@ to_tsquery('apple | orange | !banana');

CSELECT * FROM products WHERE to_tsvector(description) @@ to_tsquery('apple & orange & !banana');

DSELECT * FROM products WHERE to_tsvector(description) @@ to_tsquery('apple | orange & !banana');

Step-by-Step Solution

Solution:

Step 1: Understand logical operators in tsquery
Use parentheses to group OR conditions and AND with NOT for exclusion.
Step 2: Apply correct grouping
Expression (apple | orange) & !banana means apple or orange but not banana.
Final Answer:
SELECT * FROM products WHERE to_tsvector(description) @@ to_tsquery('(apple | orange) & !banana'); -> Option A
Quick Check:
Use parentheses for OR group with AND NOT = D [OK]

Quick Trick: Group OR terms with () before AND NOT in 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