From: | Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> |
---|---|
To: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Extracting data from jsonb array? |
Date: | 2020-12-07 22:57:18 |
Message-ID: | CAD3a31UQuYmXLuHLFtF1NTZyFSjdHfAKeSkie8GT5K_2ahAh=Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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?
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------
[
{"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
*http://agency-software.org/ <http://agency-software.org/>*
*https://demo.agency-software.org/client
<https://demo.agency-software.org/client>*
ken(dot)tanzer(at)agency-software(dot)org
(253) 245-3801
Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Baldwin | 2020-12-07 23:12:41 | Re: Extracting data from jsonb array? |
Previous Message | Ron | 2020-12-07 22:56:35 | Re: Deferrable FK not behaving as expected. |