[SQL] XML data field

[LSanchez]

Does anyone have any experience in retrieving and formatting an XML data from a field using pgSQL? Are there any system stored procs that could reformat the XML elements or just retrieve the elements needed?   Thanks! - Lily Anne