PostgreSQL - JSON and JSONB
What will be the result of this query?SELECT '{"a":1, "b":2}'::jsonb @> '{"b":2}'::jsonb;
What will be the result of this query?
medium📝 query result Q5 of 15
Step-by-Step Solution
Solution:
Step 1: Analyze the JSONB values
The left JSONB has keys "a" and "b" with values 1 and 2. The right JSONB has key "b" with value 2.Step 2: Check containment
Since the left contains the right's key-value pair, the result is true.Final Answer:
The query returns true because left contains right -> Option BQuick Check:
Containment returns true if left has right subset = A [OK]
Quick Trick: Containment returns true if all right pairs in left [OK]
Common Mistakes:
- Confusing containment direction
- Expecting false if extra keys exist
- Thinking syntax error due to casting
Master "JSON and JSONB" in PostgreSQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore PostgreSQL Quizzes