I've found a web page that contains some examples of the use of the
features in the proposed SQL/XML standard (as implemented by Oracle).
This should give us some ideas about what to aim for.
http://otn.oracle.com/tech/xml/xmldb/htdocs/sql_xml_codeexamples.html
The third example converts a query result to an XML document. (Notice
that they do not do this at the protocol level.) The other examples
process XML data within SQL using XPath/XQuery-type operations.
--
Peter Eisentraut peter_e@gmx.net