zerobearing2 wrote:
Hi all-
I'm migrating to postgres from the MS SQL Server land, as I can see a great potential with postgres, I was wondering if anyone has experimented or started a project with XML inside user defined functions?
I've seen the contrib/xml shipped with the distro, as I see it's usefulness, it's not quite what I had in mind (lacks the ablity to return recordset/table of nodes). Also, the project XpSQL seems interesting, but still not it.
I'm looking for a solution similar to the OpenXML that MS implements in their SQL Server. A way to parse XML into a table and/or a temp table for use inside a function. For example, I would like to serialize my objects into XML, send them to a postgres function for saving/updating the relational data inside postgres.
I envision something of the following could be useful:
XML ------ <table> <row field1="Testing" field2="Testing2" updateflag=1/> ... <row field1="TestingN" field2="TestingN+2" updateflag=1/> <table>
UDF ------ create function somefunc(xmldata text) begin xmldoc := preparedoc(xmldata); .... update tablename set field1=x.field1, field2=x.field2, from xmltable(xmldoc, '/table/[EMAIL PROTECTED]') as x .... preform removedoc(xmldoc); end;
Check the xml dir under contrib.
Or/And http://www.google.com/search?hl=en&lr=&ie=UTF-8&oe=utf-8&q=xml+in+postgres+site%3Apostgresql.org
C.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
