Postgres Pro
Downloads
Home   >   mailing lists

Re: Extracting data from jsonb array? - Mailing list pgsql-general

From Ken Tanzer
Subject Re: Extracting data from jsonb array?
Date
Msg-id CAD3a31VkNAbY4fvgJ9qU68MFmxt_amgRQjU4Ugt3_Q6k0y0MQw@mail.gmail.com
Whole thread Raw
In response to Re: Extracting data from jsonb array?  (Steve Baldwin <steve.baldwin@gmail.com>)
List pgsql-general
Tree view
On Mon, Dec 7, 2020 at 3:12 PM Steve Baldwin <steve.baldwin@gmail.com> 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
(253) 245-3801

learn more about AGENCY or
follow the discussion.


--
AGENCY Software  
A Free Software data system
By and for non-profits
(253) 245-3801

learn more about AGENCY or
follow the discussion.

pgsql-general by date:

Previous
From: Steve Baldwin
Date:
Subject: Re: Extracting data from jsonb array?
Next
From: "David G. Johnston"
Date:
Subject: Re: Extracting data from jsonb array?