Re: Need magic for identifieing double adresses

From: Darren Duncan <darren(at)darrenduncan(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Need magic for identifieing double adresses
Date: 2010-09-16 02:59:18
Message-ID: 4C918806.1050907@darrenduncan.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gary Chambers 2010-09-16 03:01:25 Re: Need magic for identifieing double adresses
Previous Message Andreas 2010-09-16 02:40:42 Need magic for identifieing double adresses