Databases · Middle · Question 34 of 75
What does PostgreSQL full-text search give you compared with ILIKE '%word%'?
- 1Exact substring matching only
- ✓Correct answer: Word normalization (stemming), ranking and fast GIN indexes for natural-language search
- 3Searching inside images
Explanation
to_tsvector('english', body) @@ to_tsquery('running') matches 'run' and 'runs'. For typo tolerance and facets, dedicated engines like Elasticsearch or Meilisearch go further.