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