Re: efficient compare
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Sat, 22 Apr 2006 13:56:57 GMT
Message-ID: <JCq2g.64142$VV4.1205107_at_ursa-nb00s0.nbnet.nb.ca>
>>lennart_at_kommunicera.umea.se wrote:
>>
>>
>>>-CELKO- wrote:
>>>[...]
>>>
>>>
>>>>SELECT *
>>>> FROM A EXCEPT B;
>>>
>>>Shouldnt that be
>>>
>>>SELECT * FROM A
>>>EXCEPT
>>>SELECT * FROM B;
>>>
>>>?
>>
>>But what about the tuples in B that are not in A?
Date: Sat, 22 Apr 2006 13:56:57 GMT
Message-ID: <JCq2g.64142$VV4.1205107_at_ursa-nb00s0.nbnet.nb.ca>
lennart_at_kommunicera.umea.se wrote:
> Bob Badour wrote: >
>>lennart_at_kommunicera.umea.se wrote:
>>
>>
>>>-CELKO- wrote:
>>>[...]
>>>
>>>
>>>>SELECT *
>>>> FROM A EXCEPT B;
>>>
>>>Shouldnt that be
>>>
>>>SELECT * FROM A
>>>EXCEPT
>>>SELECT * FROM B;
>>>
>>>?
>>
>>But what about the tuples in B that are not in A?
> > > Not relevant for my question. > > /Lennart
Ah, quite likely. Joe is the chief denizen of my killfile so I have no idea what was in [...] Received on Sat Apr 22 2006 - 15:56:57 CEST