Finding duplicated values

From: "Kent Anderson" <kenta(at)ezyield(dot)com>
To: "Pgsql-Sql(at)Postgresql(dot) Org" <pgsql-sql(at)postgresql(dot)org>
Subject: Finding duplicated values
Date: 2004-10-21 18:58:52
Message-ID: LPENJIOOLAIJBFKIBDKOIEAHFPAD.kenta@ezyield.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I have a few tables that have duplicated values from an import from a
different database. I have two keys I tried to set as primary and got an
error
ERROR: could not create unique index
DETAIL: Table contains duplicated values.

Is there some join I can use to compare the hmhmkey, wmwmkey pairs against
the table to find duplicate values? Each pair key should be unique but the
old database was less than normalized.

I was trying to use the code below but it returned no rows.

SELECT hmhmkey, wmwmkey
FROM exceptions
EXCEPT
SELECT hmhmkey, wmwmkey
FROM exceptions;

Any suggestions?

Kent Anderson
EZYield.com
407-629-0900
www.ezyield.com

========================================
This electronic message transmission contains information from the Company
that may be proprietary, confidential and/or privileged. The information is
intended only for the use of the individual(s) or entity named above. If
you are not the intended recipient, be aware that any disclosure, copying or
distribution or use of the contents of this information is prohibited. If
you have received this electronic transmission in error, please notify the
sender immediately by replying to the address listed in the "From:" field.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bricklen 2004-10-21 19:20:42 Re: Finding duplicated values
Previous Message David Siegal 2004-10-21 15:26:16 Re: Aggregate Function with Argument