Re: Where can I find more information of XML support in

On Sat, 2002-08-31 at 18:31, Carfield Yim wrote:
> I have find in http://www.postgresql.org/idocs and
> http://techdocs.postgresql.org/, but I can't find many information of
> XML support in PostgreSQL.
>
> Can someone give me some pointer of this?

I am the author of contrib/xml (and have just spent two days customising
it for a customer). It provides an interface for parsing XML documents
(to check whether they are well-formed) stored in "text" columns and an
interface for performing XPath queries.

As an example, executing
select pgxml_xpath(xmldoc,'string(/article/article_title)','','')
from xml_articles;

took about 70ms on a collection of 1200 documents -so it isn't as slow
as I thought it would be :)

It's in contrib because it's experimental and hasn't had a lot of
production testing (though that may be about to change - I suppose I
should fix the bug now ...)

John

--
John Gray
Azuli IT
www.azuli.co.uk