Skip to main content
Journey Uncommon Logo
JourneyUncommon
mediumSQLJSONB queryingSingle-choice MCQ

Given this JSONB column, which expression correctly returns the second tag as text ('b'), and what is the difference between -> and ->> here?

-- data column (jsonb) = '{"tags": ["a", "b", "c"]}' -- pick the expression that yields the TEXT value 'b'