[Solved] Given the table products(name TEXT) and the pg_trgm extension enabled, what does the query below return?SELECT name FROM products WHERE name % 'apple'; | PostgreSQL

PostgreSQL - Advanced Features

Given the table products(name TEXT) and the pg_trgm extension enabled, what does the query below return?

SELECT name FROM products WHERE name % 'apple';

ARows where 'name' starts with 'apple'

BRows where 'name' is similar to 'apple' based on trigram similarity

CRows where 'name' contains the substring 'apple'

DRows where 'name' exactly equals 'apple'

Step-by-Step Solution

Solution:

Step 1: Understand the operator % in pg_trgm
The % operator checks trigram similarity between strings, returning rows with similar text.
Step 2: Differentiate from other string matches
Exact match uses =, substring uses LIKE '%apple%', and starts with uses LIKE 'apple%'.
Final Answer:
Rows where 'name' is similar to 'apple' based on trigram similarity -> Option B
Quick Check:
pg_trgm % operator = trigram similarity [OK]

Quick Trick: % operator in pg_trgm means similarity match [OK]

Common Mistakes:

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Given the table products(name TEXT) and the pg_trgm extension enabled, what does the query below return?