You want to find rows in table notes where the content column contains the word 'apple' but not 'pie'. Which tsquery expression correctly achieves this?

hard📝 Application Q15 of 15

PostgreSQL - Full-Text Search

You want to find rows in table notes where the content column contains the word 'apple' but not 'pie'. Which tsquery expression correctly achieves this?

SELECT * FROM notes WHERE to_tsvector(content) @@ to_tsquery( ? );

A'apple ! pie'

B'apple | !pie'

C'apple & pie'

D'apple & !pie'

Step-by-Step Solution

Solution:

Step 1: Understand tsquery operators
& means AND, ! means NOT, | means OR.
Step 2: Construct query for 'apple' AND NOT 'pie'
The correct expression is 'apple & !pie' to include 'apple' but exclude 'pie'.
Final Answer:
'apple & !pie' -> Option D
Quick Check:
AND + NOT = & ! [OK]

Quick Trick: Use & for AND and ! for NOT in tsquery [OK]

Common Mistakes:

Using | instead of & for AND
Omitting & between terms
Incorrect spacing or missing operators

Master "Full-Text Search" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

You want to find rows in table notes where the content column contains the word 'apple' but not 'pie'. Which tsquery expression correctly achieves this?

Step 1: Understand tsquery operators

Step 2: Construct query for 'apple' AND NOT 'pie'

Final Answer:

Quick Check:

Want More Practice?