| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: returning PGresult as xml |
| Date: | 2004-01-26 16:51:21 |
| Message-ID: | 40154589.8030705@dunslane.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-01-26 17:11:19 | Re: what does it mean |
| Previous Message | ohp | 2004-01-26 16:48:34 | Re: what does it mean |