Advertisement
Guest User

Untitled

a guest
Nov 27th, 2014
176
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. create temp table t(x xml) on commit drop;
  2. insert into t values('<?xml version="1.0" encoding="UTF-8"?>
  3. <E-Document>
  4. <Document>
  5. <DocumentInfo>
  6. <DocumentNum>123</DocumentNum>
  7. </DocumentInfo>
  8. <DocumentItem>
  9. <ItemEntry>
  10. <SellerItemCode>9999999</SellerItemCode>
  11. <ItemReserve>
  12. <LotNum>(1)</LotNum>
  13. <ItemReserveUnit>
  14. <AmountActual>3.00</AmountActual>
  15. </ItemReserveUnit>
  16. </ItemReserve>
  17. </ItemEntry>
  18. </DocumentItem>
  19. </Document>
  20. </E-Document>
  21. '::xml);
  22.  
  23. SELECT
  24. unnest(xpath('/E-Document/Document/DocumentInfo/DocumentNum/text()', x))::text AS tasudok,
  25. unnest( xpath(
  26. '/E-Document/Document/DocumentParties/BuyerParty/ContactData/ContactFirstName/text()', x))::text AS ContactFirstName,
  27. unnest(xpath('/E-Document/Document/DocumentItem/ItemEntry/SellerItemCode/text()', x))::text AS toode
  28. FROM t
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement