[Solved] What will be the output of this query?SELECT to_tsquery('!apple | banana'); — Ans: '!apple' | 'banana' | PostgreSQL

PostgreSQL - Full-Text Search

What will be the output of this query?
SELECT to_tsquery('!apple | banana');

AError: invalid syntax

B'apple' & 'banana'

C'!apple' | 'banana'

D'!apple & banana'

Step-by-Step Solution

Solution:

Step 1: Parse the input string
The input uses NOT (!) on 'apple' and OR (|) with 'banana'.
Step 2: Understand to_tsquery output
The output preserves the NOT and OR operators as '!apple' | 'banana'.
Final Answer:
'!apple' | 'banana' -> Option C
Quick Check:
NOT and OR operators preserved [OK]

Quick Trick: Use ! for NOT and | for OR in to_tsquery [OK]

Common Mistakes:

Master "Full-Text Search" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What will be the output of this query?