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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
