[Solved] Why does this query fail?SELECT * FROM users WHERE profile @> '{"age": 30}';Given that profile is of type JSON, not JSONB. | PostgreSQL

PostgreSQL - JSON and JSONB

Why does this query fail?
SELECT * FROM users WHERE profile @> '{"age": 30}';
Given that profile is of type JSON, not JSONB.

AThe JSON string is invalid

BThe query is correct and should work

Cprofile column must be cast to text

DThe @> operator works only with JSONB, not JSON

Step-by-Step Solution

Solution:

Step 1: Understand operator compatibility
The @> operator is defined for JSONB type, not JSON.
Step 2: Identify type mismatch
Since profile is JSON, the operator cannot be applied directly, causing failure.
Final Answer:
@> operator requires JSONB type, not JSON -> Option D
Quick Check:
@> works only with JSONB = B [OK]

Quick Trick: Cast JSON to JSONB before using @> operator [OK]

Common Mistakes:

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Why does this query fail?