Re: Extracting data from jsonb array?
От | Ken Tanzer |
---|---|
Тема | Re: Extracting data from jsonb array? |
Дата | |
Msg-id | CAD3a31VkNAbY4fvgJ9qU68MFmxt_amgRQjU4Ugt3_Q6k0y0MQw@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Extracting data from jsonb array? (Steve Baldwin <steve.baldwin@gmail.com>) |
Список | pgsql-general |
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 SoftwareA Free Software data systemBy and for non-profits(253) 245-3801learn more about AGENCY orfollow 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 по дате отправления: