How to have xquery act like a SQL UNION?

[Ghislain Fourny]

Hi Andrew,

This XQuery Update approach actually does not alter any record - a copy-modify-return expression only modifies a copy and is hence a simple, not updating, expression (Paragraph 2.4.5 in the specification: " A transform expression is a simple expression because it does not modify the value of any existing nodes.")

Kind regards,
Ghislain


On May 12, 2010, at 5:49 PM, Andrew Webster wrote:

> Excellent.  I'll give this a try.  Much appreciated and I'll post updates as I make progress.
> 
> Ghislain's approach (using xquery update) wouldn't work as this is data of record and must not be altered.
> 
> It'll take me a few hours to get to test this, but in the meantime, thanks all for such a quick response.  You may have seen the request come from a couple of different email addresses - that was me wrestling with our corporate email "policy" - pah!
> 
> 
> Andrew Webster
> (GB Data Retention XQuery Development)