Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    2

    Unanswered: PostgreSQL and XPath

    Following the steps described in http://www.throwingbeans.org/postgresql_and_xml.html I was able to store an xml-document as a text and successfully run xpath-queries to retrieve data. However, as soon as I add namespaces and references to these in my document I run into problems. The thing is that my xpath-query returns all rows in the table without any content, as opposed to a "simple" xml-document without namespaces which would return the rows which matches my query.

    Has anyone had any experience in this area and could nudge me in the right direction ?
    Last edited by cmshp; 05-01-06 at 09:23.

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Have you seen the other throwingbeans XML/pg installment?

    http://www.throwingbeans.org/postgre...l_updated.html
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  3. #3
    Join Date
    May 2006
    Posts
    2
    Yes, but the other installment is really only valid for me in terms of installationprocedures. The actual function I'm trying to use in my java-application is as following:

    CREATE OR REPLACE FUNCTION xpath_string(text, text) RETURNS text AS 'libpgxml' LANGUAGE 'c' WITH (isStrict);

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •