PostgreSQL 8.4 XML, XSLT and XPath possibilities / documentation

The available PostgreSQL material on XML, XSLT and XPath is limited. There are the official docs from the PostgreSQL team, however these cover only a few pages of content and I've never been convinced that their do开发者_运维百科cs are as comprehensive as they could be.

There are also some bits and bobs on sites kicking around, however there is not too much.

Can anyone give me any examples of how they use the the XML functionality in PostgreSQL 8.4, or point at any hidden gem blog posts etc?

I'm especially interested in the xpath() and xslt_process() functions.

Thanks in advance!

Two (translated) articles:

• XML, XSLT and PostgreSQL
• PostgreSQL and xslt