[Solved] What will be the result of this query?SELECT * FROM articles WHERE body @@ to_tsquery('!apple | banana');Assuming body is a tsvector column. | PostgreSQL

PostgreSQL - Full-Text Search

What will be the result of this query?
SELECT * FROM articles WHERE body @@ to_tsquery('!apple | banana');
Assuming body is a tsvector column.

ARows where body contains both apple and banana

BRows where body contains apple or banana

CRows where body contains banana or does not contain apple

DRows where body contains apple but not banana

Step-by-Step Solution

Solution:

Step 1: Analyze the tsquery expression
The expression !apple | banana means NOT apple OR banana.
Step 2: Understand logical OR and NOT in tsquery
It matches rows where apple is absent or banana is present.
Final Answer:
Rows where body contains banana or does not contain apple -> Option C
Quick Check:
Logical OR with NOT = D [OK]

Quick Trick: Use ! for NOT and | for OR in tsquery with @@ [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 this query?