[Solved] What will be the output of:SELECT ts_headline('english', 'Fast and reliable PostgreSQL', to_tsquery('english', 'fast & postgresql')); | PostgreSQL

PostgreSQL - Full-Text Search

What will be the output of:
SELECT ts_headline('english', 'Fast and reliable PostgreSQL', to_tsquery('english', 'fast & postgresql'));

A'Fast and reliable PostgreSQL'

B'Fast and reliable PostgreSQL'

C'Fast and reliable PostgreSQL'

D'Fast and reliable PostgreSQL'

Step-by-Step Solution

Solution:

Step 1: Analyze the tsquery expression
The query looks for both 'fast' and 'postgresql' words.
Step 2: Determine which words get highlighted
Both 'Fast' and 'PostgreSQL' match and are highlighted.
Final Answer:
'Fast and reliable PostgreSQL' -> Option D
Quick Check:
Multiple matches highlighted correctly [OK]

Quick Trick: Use & to highlight multiple words [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: