Re: Extracting data from jsonb array?

[Ken Tanzer <ken.tanzer@xxxxxxxxx>]

On Mon, Dec 7, 2020 at 3:12 PM Steve Baldwin <steve.baldwin@xxxxxxxxx> wrote:

Try:

select _message_body->'Charges'->>'Name' from ...

Hi Steve.  I tried that again, and that returns a NULL value for me.  I believe that is because Charges holds an array of two elements, each of which has a Name element.  Though my terminology might not be correct!

Cheers,

Ken

--

AGENCY Software  

A Free Software data system

By and for non-profits

http://agency-software.org/

https://demo.agency-software.org/client

ken.tanzer@xxxxxxxxxxxxxxxxxxx

(253) 245-3801

Subscribe to the mailing list to

learn more about AGENCY or

follow the discussion.

--

AGENCY Software  

A Free Software data system

By and for non-profits

http://agency-software.org/

https://demo.agency-software.org/client

ken.tanzer@xxxxxxxxxxxxxxxxxxx

(253) 245-3801

Subscribe to the mailing list to

learn more about AGENCY or

follow the discussion.