This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
Show row differences between SELECT statements `new` and `old`. | |
The first column ("diff") will contain a '+' for rows that are in new and not in old | |
and a '-' for rows that are in old and not in new. The rest of the columns are whatever | |
new and old return. | |
If the rows in new and old share ids, then you may want to add an "ORDER BY" at the end | |
of the outer SELECT to make the two versions of the rows appear next to each other. | |
OlderNewer