6288 2008-12-08 21:26:29 +0000 [UPDUseCase] Static Typing and Parts Q3 Solution 2 2009-02-17 16:08:28 +0000 1 1 1 Unclassified XPath / XQuery / XSLT Update Facility 1.0 Use Cases Candidate Recommendation PC Windows XP CLOSED FIXED P2 normal --- 1 andrew.eisenberg jonathan.robie Tom.Brosens public-qt-comments oldest_to_newest 22710 0 andrew.eisenberg 2008-12-08 21:26:29 +0000 The query in Parts Q3 Solution 2 is: declare updating function local:delete-subtree($p as element(part)) { for $child in doc("part-list.xml")//part where $p/@partid eq $child/@partof return ( delete nodes $child, local:delete-subtree($child) ) }; for $p in doc("part-list.xml")//part[@name="car"] return local:delete-subtree($p) In Bug #5826, Tom Brosens points out that the type of $p in the function declaration should be changed to element(part, xs:untyped). 23620 1 jonathan.robie 2009-02-10 13:09:30 +0000 I am fixing this by adding a note to the example: Solution 2 (using a recursive updating function): declare updating function local:delete-subtree($p as element(part)) { for $child in doc("part-list.xml")//part where $p/@partid eq $child/@partof return ( delete nodes $child, local:delete-subtree($child) ) }; for $p in doc("part-list.xml")//part[@name="car"] return local:delete-subtree($p) NOTE: Because this data is not covered by a schema, an implementation that supports static typing will raise an error for the comparison $p/@partid eq $child/@partof. This can be solved by creating a schema for the data and importing it into the query. Please let me know if this is not sufficient. Jonathan