[Solved] Given the table products with a JSONB column attributes containing {"color": "red", "size": "M"}, what will this query return?SELECT id FROM products WHERE attributes ? 'color'; | PostgreSQL

PostgreSQL - JSON and JSONB

Given the table products with a JSONB column attributes containing {"color": "red", "size": "M"}, what will this query return?

SELECT id FROM products WHERE attributes ? 'color';

ASyntax error due to incorrect operator usage

BAll product IDs where the value of 'color' is 'red'

CAll product IDs where the 'color' key does not exist

DAll product IDs where the 'color' key exists in attributes

Step-by-Step Solution

Solution:

Step 1: Understand the query condition
The condition attributes ? 'color' checks if the key 'color' exists in the JSONB column.
Step 2: Determine the query result
It returns all rows where 'color' is a key, regardless of its value.
Final Answer:
All product IDs where the 'color' key exists in attributes -> Option D
Quick Check:
Operator '?' checks key existence, not value [OK]

Quick Trick: Remember '?' checks keys, not values [OK]

Common Mistakes:

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Given the table products with a JSONB column attributes containing {"color": "red", "size": "M"}, what will this query return?