[Solved] Why does this query fail?SELECT data->>1 FROM table_name;Assuming data is a JSON object, not an array. | PostgreSQL

PostgreSQL - JSON and JSONB

Why does this query fail?
SELECT data->>1 FROM table_name;
Assuming data is a JSON object, not an array.

Adata column is not JSON type

B->> operator cannot be used on JSON objects

CMissing quotes around 1

DUsing numeric index on JSON object instead of key

Step-by-Step Solution

Solution:

Step 1: Understand JSON object vs array access
JSON objects require string keys, arrays use numeric indexes.
Step 2: Identify misuse of numeric index on object
Using ->>1 treats 1 as key, but JSON object keys must be strings, so this fails.
Final Answer:
Using numeric index on JSON object instead of key -> Option D
Quick Check:
JSON objects need string keys, not numeric indexes [OK]

Quick Trick: Use string keys for objects, numeric indexes for arrays [OK]

Common Mistakes:

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Why does this query fail?