Easiest way to compare the results of two queries row by row and column by column

Поиск
Список
Период
Сортировка
Can someone suggest the easiest way to compare the results from two
queries to make sure they are identical?

I am rewriting a large number of views and I want to make sure that
nothing is changes in the results.

Something like

select compare_results('select * from v_old', 'select * from v_new');

I would want this to check that the row count and each row matched
column by column.

I am hoping someone has already written something for this...



В списке pgsql-general по дате отправления:

Предыдущее
От: Chris Angelico
Дата:
Сообщение: Re: coalesce function
Следующее
От: David Johnston
Дата:
Сообщение: Re: Problem with left join when moving a column to another table