Friday, August 15, 2008

[HACKERS] XML / XSL rendering in PostgreSQL server?

Hi,

I would like to use one of the XML rendering functions like table_to_xml_and_xmlschema OR table_to_xml and render the output via XSL, preferably in one query.

I've searched the mailing lists,site, docs and Google -- to no avail. Also, I see that xslt_process (from xml2) will be deprecated going forward. We're building an app that will be used for a long time into the future, and I'd like to keep it future-compatible.

I've also searched online for sql / xml docs or tutorials, but haven't found any that directly addresses using xsl in queries itself.

First, is this even possible without  xslt_process ? If so, how?

Any ideas?

Thanks a lot!

Regards,

Peter Sampson

No comments: