Re: compare two rows

Ben Kim  wrote:
 
> create table test_dup (id serial primary key, val text);
 
> How can I check whether the two rows are the same or different?
 
Well, with a primary key in there, they had *better* be different.
 
It would seem you want to see if some *subset* of the columns in two
rows match?  All columns except those in the primary key?
 
The next question is whether you want to just compare two specific
rows or list all duplicates.
 
-Kevin