Ben Kim <bkim@xxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
