On 29/06/10 09:49, J. Greg Davidson wrote:
> Hi Everybody,
>
> I'm having trouble finding any way to build up
> XML values from their logical components, e.g.
> given an XML element tag, an array of attributes
> in some form, and an xml[] array of children I
> can't find any SQL function or expression which
> would construct the XML element. Surely the
> syntactic sugary XMLPARSE must be calling such
> a function? Am I missing something or is
> PostgreSQL missing something?
The XMLELEMENT pseudo-function will do what you need.
http://www.postgresql.org/docs/current/static/functions-xml.html
--
Craig Ringer
Tech-related writing: http://soapyfrogs.blogspot.com/