[Solved] Given the table products with a json column details, what will be the result of this query?INSERT INTO products (details) VALUES ('{"color": "red", "size":... | PostgreSQL

PostgreSQL - JSON and JSONB

Given the table products with a json column details, what will be the result of this query?

INSERT INTO products (details) VALUES ('{"color": "red", "size": "M"}');
SELECT details->>'color' FROM products WHERE details->>'size' = 'M';

A["M"]

B[null]

C["red"]

DEmpty result

Step-by-Step Solution

Solution:

Step 1: Insert JSON with color and size keys
The insert adds a row with details containing color: red and size: M.
Step 2: Select color where size equals 'M'
The SELECT filters rows where details->>'size' = 'M' and returns details->>'color', which is 'red'.
Final Answer:
["red"] -> Option C
Quick Check:
Filter by size 'M' returns color 'red' [OK]

Quick Trick: Use ->> to get JSON text value for filtering and selecting [OK]

Common Mistakes:

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Given the table products with a json column details, what will be the result of this query?