[xquery-talk] outer join between 2 sequences

[Ihe Onwuka]

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>
> wrote:
>
>> > 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...
URL: <http://x-query.com/pipermail/talk/attachments/20140928/0a57d1f1/attachment.html>