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
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?
XMLPARSE/
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:/
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
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
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
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
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 even
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
• To: pgsql-novice ( at ) postgresql
13 matches
Mail list logo
