On 05/14/2013 08:48 AM, kristian kvilekval wrote:
> I was really hoping to see be able to store several ten's of millions
> XML documents in postgres, but I would also like to use Xquery to
> retrieve results. Back in 2010 there was some mailing list discussion
> about using integrating the xquery processor of zorba into postgres.
> I was trying to gauge the interest level and if anybody had attempted
> it. As you say, JSON has stolen all the thunder, and in fact the
> Zorba people have worked on JSONiq (an xquery processor for JSON data
> structures), but our project uses XML. We like the flexibility you
> get with Xquery and I am looking around for some solutions.
>
>
> On Tue, May 14, 2013 at 12:37 AM, John R Pierce <pierce(at)hogranch(dot)com
> <mailto:pierce(at)hogranch(dot)com>> wrote:
>
> On 5/13/2013 9:31 PM, kristian kvilekval wrote:
>
> I saw on the mailing list that back in 2010 there was some
> discussion of using Zorba to add xquery capabilities to
> postgres. I was wondering if any progress had been made on
> this and what the current interest levels of supporting xml in
> postgres are?
>
>
> Zorba has a JDBC database interface, and JDBC can talk to
> postgres. this would let you use zorba to query a postgres
> database via xQuery. isn't that what you want?
>
>
>
> --
> john r pierce 37N 122W
> somewhere on the middle of the left coast
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org
> <mailto:pgsql-general(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
Have you try xpath in postgres yet? We store xml, but do very little
xpathing against it. I do it mainly for trouble shooting. We have a
problem with multiple namespaces used in our content. Because of that
one is often left searching for '//*/name()="some-value"' to get around
the namespace differences inter and intra record. But xpath and
particularly xpath_table work quite well even with that constraint.