Hi,
Peter Sampson wrote:
> 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.
What do you think would be the benefit of doing that?
> 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.
You could try with one of the pl/*u languages.
Regards
Tino