Обсуждение: XML data
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
dev ss wrote > 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 XPath probably. http://www.postgresql.org/docs/9.3/interactive/functions-xml.html You may also want to reconsider your XML language specification since your use of DocumentItem is really confusing. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/XML-data-tp5794102p5794106.html Sent from the PostgreSQL - novice mailing list archive at Nabble.com.