Consider the query SELECT * FROM users WHERE data ? status; intended to check if the key 'status' exists in the JSONB column data. Why does this query fail?

medium📝 Debug Q6 of 15

PostgreSQL - JSON and JSONB

Consider the query SELECT * FROM users WHERE data ? status; intended to check if the key 'status' exists in the JSONB column data. Why does this query fail?

AThe JSONB column 'data' is not indexed

BThe key 'status' is not enclosed in single quotes, causing a syntax error

CThe operator <code>?</code> cannot be used in WHERE clauses

DThe table 'users' does not have a column named 'status'

Step-by-Step Solution

Solution:

Step 1: Analyze the query syntax
The operator ? requires the key to be a string literal.
Step 2: Identify the error
The key status is not quoted, so PostgreSQL treats it as a column or identifier, causing failure.
Final Answer:
The key 'status' is not enclosed in single quotes, causing a syntax error -> Option B
Quick Check:
Keys must be quoted strings [OK]

Quick Trick: Always quote JSONB keys in ? operator [OK]

Common Mistakes:

Forgetting to quote the key string
Assuming operator ? works without quotes
Confusing column names with key strings

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

Consider the query SELECT * FROM users WHERE data ? status; intended to check if the key 'status' exists in the JSONB column data. Why does this query fail?

Step 1: Analyze the query syntax

Step 2: Identify the error

Final Answer:

Quick Check:

Want More Practice?