extract property value from set of json arrays - Mailing list pgsql-general

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