Extracting data from jsonb array?
От | Ken Tanzer |
---|---|
Тема | Extracting data from jsonb array? |
Дата | |
Msg-id | CAD3a31UQuYmXLuHLFtF1NTZyFSjdHfAKeSkie8GT5K_2ahAh=Q@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Extracting data from jsonb array?
|
Список | pgsql-general |
Hello. This is probably simple, but I'm having a hard time making use of some json data, and hoping someone can help.
Given some data that looks like this (I added a couple of carriage returns for readability):
SELECT _message_body->'Charges' FROM message_import_court_case where _message_exchange_id=1296;
?column?
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------
[
?column?
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------
[
{"NCIC": {"Code": null, "Name": null, "Behavior": null}, "Name": "Possession Of Burglary Tools", "OffenseCodes": "9A52030;9A52060", "ClassSeverity": {"Code": "M|GM", "Description": null}},
{"NCIC": {"Code": null, "Name": null, "Behavior": null}, "Name": "Burglary In The Second Degree (Commercial)", "OffenseCodes": "9A52030", "ClassSeverity": {"Code": "F|B", "Description": null}}
]
How can I extract the two "Name" elements? (i.e.:
Possession of Burglary Tools
Burglary In The Second Degree (Commercial)
This is with 9.6.20. Thanks in advance!
Ken
--


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