Обсуждение: XML data field

Поиск
Список
Период
Сортировка

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>

Re: XML data field

От
Richard Huxton
Дата:
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