From: | celati Laurent <laurent(dot)celati(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | How to do an update with XML column ? |
Date: | 2024-12-16 16:07:05 |
Message-ID: | CAHByMH0taZ_gnh4kYYkPiOV-ZSRK-MjY=3ViMHzs4T8ddVH1MA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear all,
I'm taking the liberty to ask an question. Do you know if there are some
ways in order to update and/or do group by with an XML column ?
For instance,
select id, unnest(xpath(
'//cit:CI_Organisation/cit:name/gco:CharacterString/text()',
CAST(data AS XML),
ARRAY[
ARRAY['cit', 'http://standards.iso.org/iso/19115/-3/cit/2.0'],
ARRAY['gco', 'http://standards.iso.org/iso/19115/-3/gco/1.0'],
ARRAY['mdb','http://standards.iso.org/iso/19115/-3/mdb/2.0'],
ARRAY['cat','http://standards.iso.org/iso/19115/-3/cat/1.0'],
])) as orga_name, changedate, createdate, displayorder,
doctype, extra, popularity, rating, root, schemaid, title, istemplate,
isharvested, harvesturi,
harvestuuid, groupowner, metadata.owner, metadata.source, uuid
from public.metadata
group by orga_name
I obtained :
ERROR: could not identify an equality operator for type xml
LINE 39: group by orga_name
^
SQL state: 42883
Character: 2556
Thanks so much
From | Date | Subject | |
---|---|---|---|
Next Message | Bharani SV-forum | 2024-12-16 21:19:20 | Re: Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X |
Previous Message | Ron Johnson | 2024-12-16 15:37:59 | Re: Credcheck- credcheck.max_auth_failure |