Given the JSON column info with value '{"user": {"name": "Bob", "age": 25}}', what is the result of SELECT info #>> '{user,name}'?

medium📝 query result Q4 of 15

PostgreSQL - JSON and JSONB

Given the JSON column info with value '{"user": {"name": "Bob", "age": 25}}', what is the result of SELECT info #>> '{user,name}'?

A"Bob"

BBob

C{ "name": "Bob" }

DNULL

Step-by-Step Solution

Solution:

Step 1: Understand #>> operator
#>> extracts text value at the given path, so it returns the string without quotes.
Step 2: Apply to given JSON
At path {user,name}, the value is "Bob". Extracting text returns Bob without quotes.
Final Answer:
Bob -> Option B
Quick Check:
#>> returns text without quotes = Bob [OK]

Quick Trick: Text extraction returns unquoted string [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