Skip site navigation (1) Skip section navigation (2)

Re: Finding duplicated values

From: lorid <lorid(at)dri(dot)edu>
To: Kent Anderson <kenta(at)ezyield(dot)com>
Cc: "Pgsql-Sql(at)Postgresql(dot) Org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Finding duplicated values
Date: 2004-10-21 23:18:32
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
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
> 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
> SELECT hmhmkey, wmwmkey
> FROM  exceptions;
> Any suggestions?
> Kent Anderson
> 407-629-0900
> <>
> ========================================
> 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.

This might do it...
If you do this on the table that had duplicates you wont need to join
select count(hmhmkey),count(wmwmkey) from
exceptions group by hmhmkey,wmwmkey having count(hmhmkey) >1 or having 
count(wmwmkey) >1; 

In response to

pgsql-sql by date

Next:From: Tom LaneDate: 2004-10-21 23:32:13
Subject: Re: Trouble with explicit joins
Previous:From: Dmitry TkachDate: 2004-10-21 22:44:23
Subject: Trouble with explicit joins

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group