Am 13.11.24 um 15:58 schrieb celati Laurent:
I have a table 'metadata' with 2000 records. With one column 'id' and one
column 'data' with XML content.
I need to extract for all records the values regarding the Organisation names.
I success in querying without error message thanks to this followi
On Wednesday, November 13, 2024, celati Laurent
wrote:
>
>
> SELECT id,
> xpath('/contact/CI_ResponsibleParty/organisationName/CharacterString/text()',
>
> CAST(data AS XML)) AS organisation_name
>
>
>
> codeList="http://standards.iso.org/iso/19115/resources/Code
