Re: returning PGresult as xml
Andrew Dunstan <andrew@dunslane.net>
From: Andrew Dunstan <andrew@dunslane.net>
To: pgsql-hackers@postgresql.org
Date: 2004-01-26T16:51:21Z
Lists: pgsql-hackers
Peter Eisentraut wrote: >Let me point out an implementation I made last time this subject was >discussed: > >http://developer.postgresql.org/~petere/xmltable.tar.bz2 > >This package contains server-side functions that convert a table (more >generally a query result) to an XML document and/or and XSL schema both >mimicking the SQL/XML standard. > >Additionally, it contains a function to convert such an XML document >back to a table source. I also threw in an XSLT stylesheet to convert >an SQL/XML table to an HTML table, so you can more easily view the >results. > >I also have some code in development that adds cursor interfaces, an XML >data type, and some integration with the existing XPath functionality. >I think that for processing XML in the database and as far as following >the existing standards, this is the direction to take. > > > Peter: this looks very nice. What are your intentions with this code? Put it in contrib? Also, do you intend to implement the SQL/XML functions XMLElement, XMLForest, XMLAttributes, XMLConcat and XMLAgg? cheers andrew