Thread: XML Support

Hi Everybody,

In my research project, I need a DBMS that supports XML storage and retrieval, and provides ECA rule support.
Currently, I am using Oracle 10g. However, I am interested in using Open Sources DB.

I am looking for a document addressing the XML support in the current Postgresql release (8.1.4).
I would like to know
 - whether Postgresql DB could be used as XML Repository or not?
 - Whether Postgresql DB support the XQuery or SQL/XML or not?
 - if Yes, could I write triggers combined with SQL/XML statement or XQuery statement?

--
Regards,

Essam Mansour

On Tue, Jun 20, 2006 at 02:17:28PM +0100,
 Essam Mansour <essam.mansour@gmail.com> wrote
 a message of 35 lines which said:

> In my research project, I need a DBMS that supports XML storage and
> retrieval, and provides ECA rule support.

(No idea about ECA.)

> - whether Postgresql DB could be used as XML Repository or not?

Certainly, you can put XML in a TEXT field. Of course, without
XML-oriented retrieving tools, it is not very useful. At, least, with
xml2 (see beyond), you can insert XML and check if it is well-formed.

> - Whether Postgresql DB support the XQuery or SQL/XML or not?

Why not Xpath? It is supported in PostgreSQL (see
http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/xml2/README.xml2)
but I do not know about the performance (I don't know if there is
XML-oriented indexation).