On 1/11/06, Scott Ford <Scott(dot)Ford(at)bullfrogpower(dot)com> wrote:
> 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.
> 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?
i think what you need is a SQL to _search_ all the cases...
then look at them... and deletes them one at a time... that's the
safer way to go...
(DBA: DataBase Aniquilator ;)
In response to
pgsql-novice by date
|Next:||From: Michael Fuhr||Date: 2006-01-11 20:18:04|
|Subject: Re: Removing duplicate entries|
|Previous:||From: Scott Ford||Date: 2006-01-11 19:06:53|
|Subject: Removing duplicate entries|