SQL and/or functions that retrieves data formatted as XML then transform it to XHTML in PostgreSQL, is it possible?

Is there a way to retrieve the results of an SQL query in XML? If so how? can you provide a short example and/or a link to a good site?

Is it also possible the RDBMS can handle th开发者_如何学Ce transformation to XHTML given the XSLT? Would I want to do this anyway? Can I not send a browser XML and the XSLT and it will do the transformation itself?

I am using PostgreSQL 8.4

Yes. Here: http://www.postgresql.org/docs/8.4/interactive/functions-xml.html, here: http://wiki.postgresql.org/wiki/XML_Support and here: http://www.stylusstudio.com/sqlxml_tutorial.html.

It can using this: xslt_process(). Older browsers will not handle transforming with XSLT and IE as always does something differently but on the other hand you can offload the processing to the client.

Here its explained very well:

http://blog.sqlauthority.com/2009/02/12/sql-server-simple-example-of-creating-xml-file-using-t-sql/