Re: Need magic for identifieing double adresses - Mailing list pgsql-general

From Darren Duncan
Subject Re: Need magic for identifieing double adresses
Date
Msg-id 4C918806.1050907@darrenduncan.net
Whole thread Raw
In response to Need magic for identifieing double adresses  (Andreas <maps.on@gmx.net>)
List pgsql-general
Andreas wrote:
> I need to clean up a lot of contact data because of a merge of customer
> lists that used to be kept separate.
> I allready know that there are double entries within the lists and they
> do overlap, too.
>
> Relevant fields could be  name, street, zip, city, phone
>
> Is there a way to do something like this with postgresql ?

Yes, yes there is.  GROUP BY is your friend and there are other friends too. --
Darren Duncan

pgsql-general by date:

Previous
From: Andreas
Date:
Subject: Need magic for identifieing double adresses
Next
From: Gary Chambers
Date:
Subject: Re: Need magic for identifieing double adresses