Removing duplicate entries

From: "Scott Ford" <Scott(dot)Ford(at)bullfrogpower(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Removing duplicate entries
Date: 2006-01-11 19:06:53
Message-ID: CAA10533F41BB7448F7659D4D0671907347C6A@cx41.800onemail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all -

I have two tables - customers and documents. Each customer can be
related to several different documents. There has been a bug in some
software that's been duplicating the addition of a certain type of
document for the customers. Even though each customer can have
documents of the same type, in this case I don't want it.

customers
customer_id
...

documents
customer_id
document_id
document_type_id
...

So, for example, there are two documents with the same document_type_id
associated with one customer.

Can someone help me with a SQL statement that might help me remove the
duplicate documents for a certain document_type_id?

Thanks,
Scott.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jaime Casanova 2006-01-11 20:05:37 Re: Removing duplicate entries
Previous Message Luis Silva 2006-01-11 19:00:18 Re: convert bool result query