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 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 по дате отправления: