How to get rid of dups...

Поиск
Список
Период
Сортировка
От Jeremy Cowgar
Тема How to get rid of dups...
Дата
Msg-id 1026397832.1459.11.camel@laptop
обсуждение исходный текст
Ответ на Re: I am being interviewed by OReilly  ("Jeff MacDonald" <jeff@tsunamicreek.com>)
Список pgsql-general
I need to get rid of all rows that have dups in the columns
tpa,pun,grn,claim ... i.e.

1--- 001 001 001 00-000001 John Doe
2--- 001 001 001 00-000001 Jane Doe
3--- 001 002 001 00-000001 John Doe

1 and 2 would be dups, 1 and 3 are diff records, 2 and 3 are diff
records.

I tried this as a test:

select count(claimid), tpa, pun, grn, claim FROM claim_import GROUP BY
tpa, pun, grn, claim HAVING count(claimid) > 1;
26 rows returned.

then

select distinct on (tpa,pun,grn,claim) count(claimid), tpa, pun, grn,
claim FROM claim_import GROUP BY tpa, pun, grn, claim HAVING
count(claimid) > 1;

and still had 26 rows returned. not sure how that can happen.

Anyway, then I tried

CREATE UNIQUE INDEX tmpidx ON claim (tpa,pun,grn,claim);

that of course failed, stating dups existed.

Any help would be appreciated.

Thanks,

Jeremy






В списке pgsql-general по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Re: XML to Postgres conversion
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: was there a change in FreeBSD SHM implementation from