public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: celati Laurent <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Extract values from XML content
Date: Wed, 13 Nov 2024 11:13:00 -0700
Message-ID: <CAKFQuwaAmdC20AqHcYx_8+ha_kxQXxdbM01Wrk-K8fXxAscdiQ@mail.gmail.com> (raw)
In-Reply-To: <CAHByMH01=A2dH5ASd6tyZeRZgPnBf1CYZOC==r9=U=thYbYpKw@mail.gmail.com>
References: <CAHByMH01=A2dH5ASd6tyZeRZgPnBf1CYZOC==r9=U=thYbYpKw@mail.gmail.com>
On Wednesday, November 13, 2024, celati Laurent <[email protected]>
wrote:
>
>
> SELECT id, xpath('/contact/CI_ResponsibleParty/organisationName/CharacterString/text()',
>
> CAST(data AS XML)) AS organisation_name <mri:pointOfContact>
>
> <cit:CI_Responsibility>
> <cit:role>
> <cit:CI_RoleCode codeList="http://standards.iso.org/iso/19115/resources/Codelists/cat/codelists.xml#CI_RoleCode"; codeListValue="originator" />
> </cit:role>
> <cit:party>
> <cit:CI_Organisation>
> <cit:name>
> <gco:CharacterString>Office français de la biodiversité</gco:CharacterString>
> </cit:name>
>
>
I’d look into how to specify namespaces since your XML elements all have
them but you don’t have any in your xpath.
David J.
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Extract values from XML content
In-Reply-To: <CAKFQuwaAmdC20AqHcYx_8+ha_kxQXxdbM01Wrk-K8fXxAscdiQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox