XQuery or XPathサポート
On 3/5/07, Tatsuo Ishii <ishii@postgresql.org> wrote:
Is there any plan for supporting XQuery or XPath in 8.3?
I've submitted patch for simple XPath 1.0 support (based on libxml2):
http://archives.postgresql.org/pgsql-patches/2007-03/msg00088.php
This function does XML parsing at query time. So, you should use
functional indexes over this function to reach good perfromance.
My curent plans include development of additional contrib module for
alternative (experimental), efficient support of XPath (no XML parsing
at query time), similar to Microsoft's ORDPATHs. This project is
called "xlabel" and I hope to implement its prototype soon.
--
Best regards,
Nikolay
From: "Nikolay Samokhvalov" <samokhvalov@gmail.com>
Subject: [HACKERS] Re: [HACKERS] XQuery or XPathサポート
Date: Mon, 5 Mar 2007 14:51:43 +0300
Message-ID: <e431ff4c0703050351v781c5602hfc0c6c9976b6b139@mail.gmail.com>
On 3/5/07, Tatsuo Ishii <ishii@postgresql.org> wrote:
Is there any plan for supporting XQuery or XPath in 8.3?
I've submitted patch for simple XPath 1.0 support (based on libxml2):
http://archives.postgresql.org/pgsql-patches/2007-03/msg00088.php
But contrib/README.xml2 stated:
"This version of the XML functions provides both XPath querying and
XSLT functionality"
What's the difference between yours and contrib/xml2?
This function does XML parsing at query time. So, you should use
functional indexes over this function to reach good perfromance.My curent plans include development of additional contrib module for
alternative (experimental), efficient support of XPath (no XML parsing
at query time), similar to Microsoft's ORDPATHs. This project is
called "xlabel" and I hope to implement its prototype soon.
Also Peter seems to add xml datatype to 8.3. Does your functuion
handle this data type?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
On 3/5/07, Tatsuo Ishii <ishii@postgresql.org> wrote:
From: "Nikolay Samokhvalov" <samokhvalov@gmail.com>
I've submitted patch for simple XPath 1.0 support (based on libxml2):
http://archives.postgresql.org/pgsql-patches/2007-03/msg00088.phpBut contrib/README.xml2 stated:
"This version of the XML functions provides both XPath querying and
XSLT functionality"What's the difference between yours and contrib/xml2?
"Mine" is supposed to go to the core. And, contrib/xml2 contains less
"semantically clear" functions, that were developed for practical
purposes (e.g. xml_number() returns only one, first number from the
suquence).
This function does XML parsing at query time. So, you should use
functional indexes over this function to reach good perfromance.My curent plans include development of additional contrib module for
alternative (experimental), efficient support of XPath (no XML parsing
at query time), similar to Microsoft's ORDPATHs. This project is
called "xlabel" and I hope to implement its prototype soon.Also Peter seems to add xml datatype to 8.3. Does your functuion
handle this data type?
Of course. Peter's patches are partially based on the result of my
SoC2006 work ("Initial XML support for PostgreSQL"). XPath patch was
discussed with him and in -hackers, now I'm waiting for its review.
--
Best regards,
Nikolay
On 3/5/07, Tatsuo Ishii <ishii@postgresql.org> wrote:
From: "Nikolay Samokhvalov" <samokhvalov@gmail.com>
I've submitted patch for simple XPath 1.0 support (based on libxml2):
http://archives.postgresql.org/pgsql-patches/2007-03/msg00088.phpBut contrib/README.xml2 stated:
"This version of the XML functions provides both XPath querying and
XSLT functionality"What's the difference between yours and contrib/xml2?
"Mine" is supposed to go to the core. And, contrib/xml2 contains less
"semantically clear" functions, that were developed for practical
purposes (e.g. xml_number() returns only one, first number from the
suquence).
I see.
This function does XML parsing at query time. So, you should use
functional indexes over this function to reach good perfromance.My curent plans include development of additional contrib module for
alternative (experimental), efficient support of XPath (no XML parsing
at query time), similar to Microsoft's ORDPATHs. This project is
called "xlabel" and I hope to implement its prototype soon.Also Peter seems to add xml datatype to 8.3. Does your functuion
handle this data type?Of course. Peter's patches are partially based on the result of my
SoC2006 work ("Initial XML support for PostgreSQL"). XPath patch was
discussed with him and in -hackers, now I'm waiting for its review.
The XPath support is 1.0 or 2.0?
--
Tatsuo Ishii
SRA OSS, Inc. Japan