XML data

From: ss dev <ssdev938(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: XML data
Date: 2014-02-28 19:52:11
Message-ID: CAKYg8QQMG7h2LE0P+RBvFt4CQ9ZveBHO+aBoT4p-2ctDQny4gw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

We have data stored in a text field as XML? What is the best way to
retrieve
d54268c2-b1b5-451d-869a-7cb23c3a5d1f from the below

<?xml version="1.0" encoding="utf-8"?><Document
Version="1.0"><DocumentItem><DocumentItemEntry><DocumentItem
ItemType="DocumentItems_Image" ID="d54268c2-b1b5-451d-869a-7cb23c3a5d1f"
/></DocumentItemEntry></DocumentItem><DocumentSource
/><ConditionID>00000000-0000-0000-0000-000000000000</ConditionID></Document>

Thanks,
Dev

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message David Johnston 2014-02-28 20:15:41 Re: XML data
Previous Message Simon Riggs 2014-02-28 08:20:59 Re: Override PostgreSQL internal functions