[GENERAL] Re: Easiest way to compare the results of two queries row by row and column by column

2016-08-22 Thread gilad905
Didn't mean to give the impression I'm 'shouting' :) just wanted to make sure other users will notice my reply. But you're right! it does. It even disregards the order of the rows. For some reason in a previous test I looked to me like it didn't. -- View this message in context: http://postgres

[GENERAL] Re: Easiest way to compare the results of two queries row by row and column by column

2016-08-17 Thread gilad905
Vik, note that your new suggestion for a query might be more readable/efficient than Jeff's, but IT STILL DOESN'T SOLVE THE PROBLEM OF DETECTING DUPLICATE ROWS. -- View this message in context: http://postgresql.nabble.com/Easiest-way-to-compare-the-results-of-two-queries-row-by-row-and-column-