[Solved] Identify the error in this query that tries to find rows where info JSONB column contains {"active": true}:SELECT * FROM users WHERE info @> '{active: true}'; | PostgreSQL

PostgreSQL - JSON and JSONB

Identify the error in this query that tries to find rows where info JSONB column contains {"active": true}:

SELECT * FROM users WHERE info @> '{active: true}';

AWrong operator used, should be <@

BJSON keys must be in double quotes

CMissing cast to jsonb for the right side

DBoolean true must be in quotes

Step-by-Step Solution

Solution:

Step 1: Check JSON syntax correctness
JSON keys must be enclosed in double quotes, so active should be "active".
Step 2: Verify casting and operator
The query is missing ::jsonb cast, but the main syntax error is the missing quotes around the key.
Final Answer:
JSON keys must be in double quotes -> Option B
Quick Check:
JSON keys need double quotes [OK]

Quick Trick: Always quote JSON keys and cast string to jsonb [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 that tries to find rows where info JSONB column contains {"active": true}: