[Solved] What will be the result of this query on a table users with a GIN index on JSONB column profile?SELECT * FROM users WHERE profile @> '{"age": 30}';Assuming some rows have "age":... | PostgreSQL

PostgreSQL - JSON and JSONB

What will be the result of this query on a table users with a GIN index on JSONB column profile?

SELECT * FROM users WHERE profile @> '{"age": 30}';

Assuming some rows have "age": 30 inside their JSONB data.

AIt returns all rows where the profile JSONB contains the key "age" with value 30.

BIt returns all rows where the profile JSONB contains the key "age" with any value.

CIt returns no rows because the query syntax is invalid.

DIt returns all rows regardless of the profile content.

Step-by-Step Solution

Solution:

Step 1: Analyze the query condition
The condition profile @> '{"age": 30}' means profile must contain key "age" with value 30.
Step 2: Understand GIN index effect
The GIN index speeds up this containment check but does not change the result set.
Final Answer:
It returns all rows where the profile JSONB contains the key "age" with value 30. -> Option A
Quick Check:
Query returns rows containing specified key-value pair [OK]

Quick Trick: GIN index speeds up @> queries but does not change results [OK]

Common Mistakes:

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What will be the result of this query on a table users with a GIN index on JSONB column profile?