[Solved] Given the table users with a JSON column profile, what does this query return?SELECT profile->>'name' FROM users WHERE profile->>'age' = '30'; | PostgreSQL

PostgreSQL - JSON and JSONB

Given the table users with a JSON column profile, what does this query return?

SELECT profile->>'name' FROM users WHERE profile->>'age' = '30';

AAn error because ->> cannot be used in WHERE.

BAll JSON profiles where age is 30.

CNames of users whose age is 30 as text values.

DAge values of users named '30'.

Step-by-Step Solution

Solution:

Step 1: Understand JSON operators
The operator ->> extracts JSON object field as text. Here, profile->>'age' gets age as text.
Step 2: Analyze query logic
The WHERE clause filters rows where age equals '30'. The SELECT returns the name field as text for those rows.
Final Answer:
Names of users whose age is 30 as text values. -> Option C
Quick Check:
->> extracts text field = names for age 30 [OK]

Quick Trick: ->> extracts text; WHERE filters JSON text fields [OK]

Common Mistakes:

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Given the table users with a JSON column profile, what does this query return?