Given the table products with a JSON column info containing {"price": 100, "details": {"color": "red"}}, what is the output of this query?

medium📝 query result Q13 of 15

PostgreSQL - JSON and JSONB

Given the table products with a JSON column info containing {"price": 100, "details": {"color": "red"}}, what is the output of this query?

SELECT info->'details'->>'color' FROM products;

Ared

BNULL

C{ "color": "red" }

D"red"

Step-by-Step Solution

Solution:

Step 1: Understand nested arrow operators
The first -> extracts the JSON object at key 'details'. The second ->> extracts the text value of 'color'.
Step 2: Determine output format
->> returns text without quotes, so output is plain text 'red'.
Final Answer:
red -> Option A
Quick Check:
Nested -> and ->> extract text correctly [OK]

Quick Trick: Use -> for JSON, ->> for text even in nested keys [OK]

Common Mistakes:

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free