Re: [SQL] Finding duplicated values

2004-10-25 Thread Bricklen
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

Re: [SQL] Finding duplicated values

2004-10-22 Thread Christoph Haller
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 compa

Re: [SQL] Finding duplicated values

2004-10-21 Thread lorid
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 u

Re: [SQL] Finding duplicated values

2004-10-21 Thread Stephan Szabo
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 > ERROR: could not create unique index > DETAIL: Table contains duplicated values. > > Is there som

[SQL] Finding duplicated values

2004-10-21 Thread Kent Anderson
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 indexDETAIL:  Table contains duplicated values.   Is there some join I can use to compare the hmhmkey, wmwmke