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).