By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,731 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,731 IT Pros & Developers. It's quick & easy.

Postgres+XML

P: n/a
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
Nov 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.