Re: differences
From: Brian Smith <brian-l-smith_at_uiowa.edu>
Date: 31 Jan 2002 04:14:35 -0800
Message-ID: <60360d48.0201310414.776f07bf_at_posting.google.com>
Date: 31 Jan 2002 04:14:35 -0800
Message-ID: <60360d48.0201310414.776f07bf_at_posting.google.com>
mikharakiri_at_yahoo.com (Mikito Harakiri) wrote in message news:<bdf69bdf.0201290944.45620dd_at_posting.google.com>...
> what is a SQL query that returns all the differences between A and B?
> It is important that position is used for ordering only, so that it is
> pretty much like I'm comparing 2 text files. UNIX diff utility does
> exactly that, but query must be superior, right?-)
Do you expect the results to be the same as the results from UNIX diff? If you just want to know which lines are different, that isn't two bad. But diff actually gives you an output consisting of (a) lines added, (b) lines removed, and (c) lines that are consistent between the two inputs.
- Brian