Re: XML data

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.