By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
1 rows affected
1 rows affected
| id | data | val |
|---|---|---|
| 1 | [{"a": 3, "b": "green"}, {"a": 5, "b": "blue"}] | green |
| 2 | [{"a": 3, "b": "red"}, {"a": 5, "b": "yellow"}] | yellow |