[xquery-talk] outer join between 2 sequences
ihe.onwuka at gmail.com
Sun Sep 28 04:56:22 PDT 2014
On Sun, Sep 28, 2014 at 12:42 PM, Ihe Onwuka <ihe.onwuka at gmail.com> wrote:
> On Sun, Sep 28, 2014 at 12:32 PM, Adam Retter <adam.retter at googlemail.com>
>> > I have sequence A consisting of the numbers 0 to 4000000 and sequnce B
>> > consisting of about 100k random I numbers within the range of sequence
>> A and
>> > I want the outer join where sequence B is "null".
>> There is no 'null' in XQuery, so I am not quite sure what you mean
>> here. If you ware looking for all values that appear in sequence A and
>> sequence B, then you can do the following -
>> $a[. = $b]
> I meant null in the SQL sense of outer join - sorry.
> I want to drop the things that are in B from A where both B and A are just
> sequences of integers. In other words, don't fetch what I've already got.
Pah... incorrect snippage in the last post.
Of course that would be $a[not(. = $b)] maybe even $a except $b, I was
asking more on what the performance expectation would be.
Pleased that it reasonable to expect it to be fast.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the talk