On Thu, 21 Oct 2004, Kent Anderson wrote:
> 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: 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.
SELECT hmhmkey, wmwmkey
GROUP BY hmhmkey, wmwmkey
In response to
pgsql-sql by date
|Next:||From: Dmitry Tkach||Date: 2004-10-21 22:44:23|
|Subject: Trouble with explicit joins|
|Previous:||From: Bricklen||Date: 2004-10-21 19:20:42|
|Subject: Re: Finding duplicated values|