[Solved] You wrote this query but get an error:SELECT * FROM my_table WHERE data @> '{"key": "value"}';What is the most likely cause? | PostgreSQL

PostgreSQL - Advanced Features

You wrote this query but get an error:
SELECT * FROM my_table WHERE data @> '{"key": "value"}';
What is the most likely cause?

AThe @> operator is invalid syntax

BThe table my_table does not exist

CThe JSON string is malformed

DThe data column is not of JSONB type

Step-by-Step Solution

Solution:

Step 1: Understand the @> operator
@> is the JSONB containment operator, valid only on JSONB columns.
Step 2: Check data column type
If data is JSON (not JSONB), @> operator causes an error.
Final Answer:
The data column is not of JSONB type -> Option D
Quick Check:
@> requires JSONB column type [OK]

Quick Trick: Use JSONB type for @> containment operator [OK]

Common Mistakes:

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

You wrote this query but get an error: