Re: How to find double entries

by craig@[EMAIL PROTECTED] (Craig Ringer) Apr 16, 2008 at 12:22 PM

Andreas wrote:
> Hi,
> 
> how can I find double entries in varchar columns where the content is
> not 100% identical because of a spelling error or the person considered
> it "looked nicer" that way?

When doing some near-duplicate elimination as part of converting a
legacy data set to PostgreSQL I found the `fuzzystrmatch' contrib module
immensely helpful.

http://www.postgresql.org/docs/current/static/fuzzystrmatch.html

--
Craig Ringer

-- 
Sent via pgsql-sql mailing list (pgsql-sql@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

8 Posts in Topic:

How to find double entries

maps.on@[EMAIL PROTECTED]

2008-04-16 05:15:43

Re: How to find double entries

craig@[EMAIL PROTECTED]

2008-04-16 12:22:57

Re: How to find double entries

tgl@[EMAIL PROTECTED] (T

2008-04-15 23:23:32

Re: How to find double entries

vivek@[EMAIL PROTECTED]