Hello!
CSN [EMAIL PROTECTED] wrote:
> I have a table that relates id's of two other tables:
>
> table1id, table2id
>
> Dupes have found their way into it (create unique index
> across both fields fails). Is there a quick and easy way to
> find and delete the dupes (there are tens of thousands of
Nevermind, figured it out:
select distinct on (table1id, table2id) * into temp
from table3;
delete from table3;
insert into table3 select * from temp;
--- CSN <[EMAIL PROTECTED]> wrote:
> I have a table that relates id's of two other
> tables:
>
> table1id, table2id
>
> Dupes have found the
I have a table that relates id's of two other tables:
table1id, table2id
Dupes have found their way into it (create unique
index across both fields fails). Is there a quick and
easy way to find and delete the dupes (there are tens
of thousands of records)?
Thanks,
CSN
