PostgreSQL - JSON and JSONB
Which JSONB expression will return true for '{"a":1, "b":2}'::jsonb @> ?
Which JSONB expression will return true for '{"a":1, "b":2}'::jsonb @> ?
easy📝 Conceptual Q2 of 15
Step-by-Step Solution
Solution:
Step 1: Check if left JSONB contains right JSONB
The left JSONB is {"a":1, "b":2}. It contains {"a":1} because key "a" with value 1 exists.Step 2: Verify other options
The other options have either wrong values or keys not present in the left JSONB.Final Answer:
Only {"a":1} is contained in the left JSONB -> Option CQuick Check:
Containment matches exact key-value pairs = C [OK]
Quick Trick: Values must match exactly for containment [OK]
Common Mistakes:
- Assuming key presence is enough without matching value
- Confusing containment direction
- Ignoring value differences
Master "JSON and JSONB" in PostgreSQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore PostgreSQL Quizzes