[Solved] Why does this query cause an error?SELECT data->>'name' FROM users WHERE data->'age' > 25; — Ans: Cannot compare JSON object with integer directly. | PostgreSQL

PostgreSQL - JSON and JSONB

Why does this query cause an error?
SELECT data->>'name' FROM users WHERE data->'age' > 25;

Adata->>'name' is invalid syntax.

BCannot compare JSON object with integer directly.

CMissing FROM clause.

DJSON keys must be in double quotes.

Step-by-Step Solution

Solution:

Step 1: Analyze WHERE clause
data->'age' returns JSON object, which cannot be compared to integer 25.
Step 2: Correct approach
Use data->>'age' to get text, then cast to integer for comparison.
Final Answer:
Cannot compare JSON object with integer directly. -> Option B
Quick Check:
Compare JSON text or cast, not JSON object [OK]

Quick Trick: Use ->> to get text before comparing JSON values [OK]

Common Mistakes:

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Why does this query cause an error?