[Solved] Given the table items with a JSONB column attributes, what will this query return?SELECT id FROM items WHERE attributes @> '{"color":... | PostgreSQL

PostgreSQL - JSON and JSONB

Given the table items with a JSONB column attributes, what will this query return?

SELECT id FROM items WHERE attributes @> '{"color": "red"}'::jsonb;

Assuming items contains:

id | attributes
---+-------------------------
1  | {"color": "red", "size": "M"}
2  | {"color": "blue", "size": "L"}
3  | {"color": "red"}
4  | {"size": "S"}

A[4]

B[2, 4]

C[1, 3]

D[1, 2, 3]

Step-by-Step Solution

Solution:

Step 1: Understand the query condition
The query selects rows where attributes contain the JSON {"color": "red"}.
Step 2: Check each row's attributes
Rows 1 and 3 have "color": "red"; rows 2 and 4 do not.
Final Answer:
[1, 3] -> Option C
Quick Check:
Only rows with color red = [1, 3] [OK]

Quick Trick: Look for rows where JSON contains the key-value pair exactly [OK]

Common Mistakes:

Including rows without the key-value pair
Confusing @> with key existence operator
Ignoring the JSONB cast requirement

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 the table items with a JSONB column attributes, what will this query return?

Step 1: Understand the query condition

Step 2: Check each row's attributes

Final Answer:

Quick Check:

Want More Practice?