Re: [GENERAL] How to add xml data to table

2011-10-09 Thread Andrus
-Algsõnum- From: Francisco Figueiredo Jr. Sent: Saturday, October 08, 2011 9:38 PM To: Andrus Moor Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] How to add xml data to table I think your best bet would be to go with XmlReader as it provides a fast read only parsing of the document

Re: [GENERAL] How to add xml data to table

2011-10-09 Thread Andrus
implemented ? Andrus. -Algsõnum- From: Francisco Figueiredo Jr. Sent: Saturday, October 08, 2011 11:26 PM To: Andrus Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] How to add xml data to table I think this approach is much better as you can solve everything on server itself

Re: [GENERAL] How to add xml data to table

2011-10-08 Thread Francisco Figueiredo Jr.
dure periodically after every one hour in server? > > In this case we can create stored procedure, client side code is not > nessecary at > all. > > Andrus. > > -Algsõnum- From: Francisco Figueiredo Jr. > Sent: Saturday, October 08, 2011 9:38 PM > To: Andrus Moor &

Re: [GENERAL] How to add xml data to table

2011-10-08 Thread Francisco Figueiredo Jr.
I think your best bet would be to go with XmlReader as it provides a fast read only parsing of the document. >From MS doc about linq to xml: http://msdn.microsoft.com/en-us/library/bb387048.aspx "XmlReader is a fast, forward-only, non-caching parser. LINQ to XML is implemented on top of XmlReade

[GENERAL] How to add xml data to table

2011-10-07 Thread Andrus Moor
soap response below contains table of products, approx 5000 rows. Table of products (below) is nearly similar structure as xml data. Products table needs to be updated from xml data in every hour. How to add this xml data to table of products ? Should I use xpath() function or any other ides ? U