Re: returning PGresult as xml - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: returning PGresult as xml
Date
Msg-id 40154589.8030705@dunslane.net
Whole thread Raw
In response to Re: returning PGresult as xml  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: returning PGresult as xml  (Peter Eisentraut <peter_e@gmx.net>)
List 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



pgsql-hackers by date:

Previous
From: ohp@pyrenet.fr
Date:
Subject: Re: what does it mean
Next
From: "Thomas Hallgren"
Date:
Subject: Functions returning complex types.