Jsonb array elements

Question

How to extract data from a jsonb column

Data Table

Id	Result
1001	{"Green": {"value": "250.3", "reading": "250.3"}, "MbSampleType": {"value": "Water"}}
1002	{"Green": {"value": "0", "reading": "0"}, "Yellow": {"value": "560", "reading": "560"}, "TotalVibrio": {"value": "560", "reading": "560"}, "MbSampleType": {"value": "water"}}}

Result should come out as follows

where key_value = 'Green'

You should at least deliver a bit of code to show that you tried something, use [this fiddle](https://dbfiddle.uk/?rdbms=postgres_14&fiddle=7d161b223d98f48bd92b6cc1c2fffd65) for instance — Reynadan, Jul 15 '22 at 12:25
Why doe you expect `MbSampleType` in the result if you want `where key_value = 'Green'`? — , Jul 15 '22 at 13:05

score 0 · Accepted Answer · answered Jul 15 '22 at 12:25

0

select result -> 'green' as key_value
from table

answered Jul 15 '22 at 12:25

Kas

1 Answers1