[Solved] Identify the error in this query:SELECT info->>age FROM customers;Assuming info is a JSON column. — Ans: Missing quotes around 'age' key | PostgreSQL

PostgreSQL - JSON and JSONB

Identify the error in this query:
SELECT info->>age FROM customers;
Assuming info is a JSON column.

AMissing quotes around 'age' key

BUsing ->> instead of ->

Cinfo column is not JSON type

DNo error, query is correct

Step-by-Step Solution

Solution:

Step 1: Check JSON key syntax
JSON keys must be string literals in quotes when used with -> or ->> operators.
Step 2: Identify missing quotes
The key age is not quoted, causing a syntax error.
Final Answer:
Missing quotes around 'age' key -> Option A
Quick Check:
JSON keys require quotes in -> and ->> [OK]

Quick Trick: Always quote JSON keys as strings [OK]

Common Mistakes:

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Identify the error in this query: