dbTalk Databases Forums  

Postgres+XML

comp.databases.postgresql.general comp.databases.postgresql.general


Discuss Postgres+XML in the comp.databases.postgresql.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jan Szumiec
 
Posts: n/a

Default Postgres+XML - 01-25-2005 , 05:32 PM






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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.