[Solved] Given a table products with a JSONB column attributes and a GIN index on it, what will this query return?SELECT * FROM products WHERE attributes @> '{"color": "red"}'; | PostgreSQL

PostgreSQL - JSON and JSONB

Given a table products with a JSONB column attributes and a GIN index on it, what will this query return?

SELECT * FROM products WHERE attributes @> '{"color": "red"}';

AAll rows where the JSONB column contains the key "color" with value "red"

BAll rows where the JSONB column contains any key named "color"

CAll rows where the JSONB column contains the value "red" anywhere

DSyntax error due to incorrect JSON format

Step-by-Step Solution

Solution:

Step 1: Understand the @> operator
The @> operator checks if the left JSONB contains the right JSONB as a subset, meaning the key-value pair must exist exactly.
Step 2: Analyze the query condition
The condition attributes @> '{"color": "red"}' means the JSONB column must have a key "color" with value "red".
Final Answer:
All rows where the JSONB column contains the key "color" with value "red" -> Option A
Quick Check:
@> means contains key-value pair exactly [OK]

Quick Trick: Use @> to find exact key-value pairs in JSONB [OK]

Common Mistakes:

Thinking @> matches only keys, not values
Assuming it matches any occurrence of value
Confusing JSON syntax causing errors

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Given a table products with a JSONB column attributes and a GIN index on it, what will this query return?

Step 1: Understand the @> operator

Step 2: Analyze the query condition

Final Answer:

Quick Check:

Want More Practice?