[Solved] Why does this query fail?SELECT jsonb_set(data, '{location,city}', '"New York"') FROM table;Assuming data has no key location. | PostgreSQL

PostgreSQL - JSON and JSONB

Why does this query fail?
SELECT jsonb_set(data, '{location,city}', '"New York"') FROM table;
Assuming data has no key location.

ABecause the data column is not JSONB type

BBecause '"New York"' is not valid JSON

CBecause jsonb_set cannot update nested keys

DBecause the path includes a missing intermediate key and create_missing is false by default

Step-by-Step Solution

Solution:

Step 1: Check path existence
The path '{location,city}' requires the key 'location' to exist if create_missing is not set to true.
Step 2: Default behavior
By default, create_missing is false, so the function fails if intermediate keys are missing.
Final Answer:
Because the path includes a missing intermediate key and create_missing is false by default -> Option D
Quick Check:
Missing intermediate keys cause jsonb_set failure [OK]

Quick Trick: Missing path keys cause jsonb_set errors [OK]

Common Mistakes:

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Why does this query fail?