Re: [GENERAL] XML Support related questions

2008-05-27 Thread Peter Eisentraut
Brijesh Shrivastav wrote: For #4 I was looking to be able to index some or all of the tags in the xml document. Most of our applications query very few tags in a Xml document and a smaller index on few tags will help with query performance. Expression indexes on xpath are probably what you

Re: [GENERAL] XML Support related questions

2008-05-24 Thread Peter Eisentraut
Am Donnerstag, 22. Mai 2008 schrieb Brijesh Shrivastav: 1) Can xml column be constrained to be DOCUMENT or CONTENT type? Using a check constraint that does IS [NOT] DOCUMENT on the value. 2) Is there plan in near future to support XML schema validation i.e to ensure inserted xml

Re: [GENERAL] XML Support related questions

2008-05-23 Thread Stephane Bortzmeyer
On Thu, May 22, 2008 at 11:49:38AM -0700, Brijesh Shrivastav [EMAIL PROTECTED] wrote a message of 251 lines which said: 2) Is there plan in near future to support XML schema validation i.e to ensure inserted xml document conforms to a preregistered set of XML schemas. It seems quite heavy

Re: [GENERAL] XML Support related questions

2008-05-23 Thread Craig Ringer
Brijesh Shrivastav wrote: 1) Can xml column be constrained to be DOCUMENT or CONTENT type? XMLPARSE/XMLSERIALIZE functions allows to set XML option DOCUMENT or CONTENT type. Can we do the same when defining an xml column level? Maybe this could be done with a PL trigger ? Ideally you'd

[GENERAL] XML Support related questions

2008-05-22 Thread Brijesh Shrivastav
Hello PostgreSQL XML Experts, I was exploring xml support in postgreSQL and ran into few questions answer to which I couldn't find easily in the documentation. I would appreciate responses to following queries: 1) Can xml column be constrained to be DOCUMENT or CONTENT type?

[GENERAL] XML-support

2008-01-30 Thread Sigurd Nes
Hi, I noticed the upcoming support for xml in 8.3: Does anybody know if this allows updates, inserts,removes and renames of nodes to a XML-document (as for Xindice)? Regards Sigurd Nes ---(end of broadcast)--- TIP 3: Have you checked our extensive

Re: [GENERAL] XML-support

2008-01-30 Thread Peter Eisentraut
Sigurd Nes wrote: I noticed the upcoming support for xml in 8.3: Does anybody know if this allows updates, inserts,removes and renames of nodes to a XML-document (as for Xindice)? No, it doesn't support that directly. I guess you could achieve it by using XSLT. -- Peter Eisentraut

[GENERAL] XML Support

2006-06-22 Thread Essam Mansour
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

Re: [GENERAL] XML Support

2006-06-22 Thread Stephane Bortzmeyer
On Tue, Jun 20, 2006 at 02:17:28PM +0100, Essam Mansour [EMAIL PROTECTED] 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

[GENERAL] XML Support

2006-05-26 Thread Thomas Kellerer
Hello, I'm trying to use XML with PG, and I a descriptioin of the XML support for PostgreSQL at http://www.throwingbeans.org/postgresql_and_xml_updated.html As I could not find the mentioned package in my Windows installation (8.1.3) I thought I'd give the package from that website a try

Re: [GENERAL] XML Support

2006-05-26 Thread John Gray
On Fri, 26 May 2006 13:25:34 +0200, Thomas Kellerer wrote: Hello, I'm trying to use XML with PG, and I a descriptioin of the XML support for PostgreSQL at http://www.throwingbeans.org/postgresql_and_xml_updated.html As I could not find the mentioned package in my Windows installation

Re: [GENERAL] XML Support

2006-05-26 Thread Thomas Kellerer
John Gray wrote on 26.05.2006 22:01: I can't claim to have great Windows compilation skills, but another contributor posted a zipped dll some time ago: http://archives.postgresql.org/pgsql-novice/2005-11/msg00216.php That may help you out. Thanks for the pointer, but I can't seem to get

[GENERAL] xml support on win32 postgres

2006-01-25 Thread [EMAIL PROTECTED]
Ok, I decided to upgrade my postgress version to 8.1, I am using a win32 distribution, where can I find the xml2 extension? I got the pgxml distribution from http://www.u-moe.org/pgxml/ and I followed all tips from George • From: George Weaver gweaver ( at ) shaw ( dot ) ca • To: