Working with XML.

Hi Folks,

Is there a way to pass in an xml string into a stored proc and thenplace
this into a temp table?

I use to be able to do this in sql server, it was quite handy as I could
call one stored proc to update multiple records, here is a sample in sql
server:

select CoverTypeID, ItemSQ, SituationID, ItemDescription, CoverAmount
>From OpenXML ( @XmlHandle, '/cover/covertype/item',1 )
With ( CoverTypeID int '../@id',
ItemSQ int '@id',
SituationID int '@situationID',
ItemDescription varchar(100) '@description',
CoverAmount money '@amount' )

I have managed to get get pgxml_xpath working, however Im not sure how to
access specific rows in an xml document. E.g below there are two records,
how do I access the second record, the following returns both
,'//query/row/cola values being (284122,525887):

select
pgxml_xpath(
'<query columns="4"
rows="100"><row><cola>284122</cola><colb>789648</colb><colc>{ts ''2005-02-14
16:13:18''}</colc><cold>unbnda8m5946z55sgi1xco34h1q9tLonoys3nyk1d5tgtLaw8h5w
ya0zdv7vigeiuk9xqLuacdy0dsisopb8g1o4o76090otmq65</cold></row<row><cola>52588
7</cola><colb>493253</colb><colc>{ts ''2005-02-14
16:13:18''}</colc><cold>6uydk442uz247ga45kpys7htkxznkn8La31qhn942wu2cu2pdr25
mv2nup2zh3vcbh3c4vdauak3p3w093cvtkeyga692b455cr3</cold></row></query>'
,'//query/row/cola/text()','','')

______________________________________________________________________
This email, including attachments, is intended only for the addressee
and may be confidential, privileged and subject to copyright. If you
have received this email in error, please advise the sender and delete
it. If you are not the intended recipient of this email, you must not
use, copy or disclose its content to anyone. You must not copy or
communicate to others content that is confidential or subject to
copyright, unless you have the consent of the content owner.