Login or Sign up Help | Site Map
Connecting Tech Pros Worldwide

Postgres+XML

Question posted by: Jan Szumiec (Guest) on November 23rd, 2005 02:03 AM
Hi,

First of all I'd like to say that 8.0 is a great piece of software, and
I've been looking forward to installing 8.0 for quite some time now.

Does PG allow you to store XML documents as DOM documents? Is there such
data type? If not, is it very hard to extend the type system to include
a binary representation of an XML document?

What I'm trying to do is the following:

SELECT AVERAGE(xpath_query('/ds/item[@name=\'left\']') GROUP BY language;

Now, I could probably write a function in either PL/Perl or Python that
would be able to parse the document tree from a text column and process
it accordingly. Does PL/Perl work exactly the same way as regular perl?
Eg. Can I import a class (for manipulating XML, for example), and then
use it in my function?

Thanks,
jps
Would you like to answer this question?
Sign up for a free account, or Login (if you're already a member).
 
Not the answer you were looking for? Post your question . . .
184,011 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Latest Articles: Read & Comment
  • Didn't find the answer you were looking for?
    Post Your Question
  • Top Community Contributors