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
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 d
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 d
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 he
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
http:/
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
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 that
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
