Is there a way to get recordset out of XML document - something similair
to contrib/xml2's xpath_table function, but I'd like to be able to get
data out of XML document that is not stored in the database.
I wrote my own plpgsql function for converting XML document data to
recordset (table), bu
Hello.
I've read the documentation, I think I have even found the article
after which this part of documentation has been updated
(http://markmail.org/thread/ys2a2yph5zgmnls5) but I still can't write
appropriate query :-(.
Let's consider the following:
create table test_xml (id serial primary k
Hi,
I am using xpath_table to convert elements from an XML column to "rows".
Now according to
http://www.postgresql.org/docs/8.3/static/xml2.html
this function will be removed in a future version.
That chapter also claims that the new XML syntax covers the functionality of
the xml2 module,
