On Mon, Dec 7, 2020 at 4:13 PM Steve Baldwin <steve.bald...@gmail.com> wrote:
> Try: > > select _message_body->'Charges'->>'Name' from ... > Not so much..."Charges" is an array so "->>" doesn't do anything useful. The OP needs to use "json_array_elements" to navigate past the array and get to the next layer of the json where ->>'Name' will then work. For v12 and newer readers, SQL/JSON Path should probably be used instead. David J.
