|
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
| 
