[Solved] What does the PostgreSQL @> operator do when used with JSONB data? — Ans: Checks if the left JSONB contains the right JSONB | PostgreSQL

PostgreSQL - JSON and JSONB

What does the PostgreSQL @> operator do when used with JSONB data?

AChecks if the right JSONB contains the left JSONB

BDeletes the right JSONB from the left JSONB

CMerges two JSONB objects into one

DChecks if the left JSONB contains the right JSONB

Step-by-Step Solution

Solution:

Step 1: Understand the operator's purpose
The @> operator in PostgreSQL is used to check containment between JSONB values.
Step 2: Identify the direction of containment
It checks if the JSONB on the left side contains the JSONB on the right side.
Final Answer:
Checks if the left JSONB contains the right JSONB -> Option D
Quick Check:
JSONB containment = left contains right [OK]

Quick Trick: Remember: left @> right means left contains right [OK]

Common Mistakes:

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What does the PostgreSQL @> operator do when used with JSONB data?