Обсуждение: XML data field
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Does anyone have any experience in retrieving and formatting an XML data from a field using <span class="SpellE">pgSQL</span>?Are there any system stored <span class="SpellE">procs</span> that could reformat the XML elementsor just retrieve the elements needed?</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Thanks!</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">- Lily Anne </span></font></div>
LSanchez@ameritrade.com wrote: > 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? There are some xml-related functions in the contrib/ directory of the source folder. Haven't used them myself, so can't say more. Worth checking the mailing list archives though, since there has been discussion of this. -- Richard Huxton Archonet Ltd