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

Reply via email to