I have the following in a postgresql table
row 1: {"a": 1, "b": "[{"c": "123", "d":"456", "e": "789"},
{"c": "222", "d":"111", "e": "000"}
]"}
row 2: {"a": 2, "b": "[{"c": "XXX", "d":"YYY", "e": "ZZZ"},
{"c": "666", "d":"444", "e": "333"}
]"}
How do I pullout all "b":"e" values and end up with this result:
789
000
ZZZ
333
