Hi,

I'm in the process of converting a LAMP AJAX website from MySQL to
PostgreSQL. I'm having trouble finding resources regarding XML
manipulation in pl/pgsql. Specifically, I'm trying to do the following
(provided as MySQL code):
SET vEmail = ExtractValue(pDetailsXML,'/userdetails/email');
which returns a single value from a specified node, and
SET pNewDetailsXML =
UpdateXML(pDetailsXML,'/userdetails/email',CONCAT('<email>',vEmail,'</email>'));
which replaces a specified node in the XML (and assigns the new XML to a
different variable).

Any URLs or sample code would be appreciated.

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/