Re: Merge rows based on Levenshtein distance

From: pinker <pinker(at)onet(dot)eu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Merge rows based on Levenshtein distance
Date: 2014-12-03 16:14:02
Message-ID: 1417623242791-5829111.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

There is nice extension in postgres: fuzzystrmatch
<http://www.postgresql.org/docs/9.3/static/fuzzystrmatch.html> I have used
to calculate the distance. From documetation:

SELECT levenshtein_less_equal('extensive', 'exhaustive',2);

You can use it then with your group by query.

--
View this message in context: http://postgresql.nabble.com/Merge-rows-based-on-Levenshtein-distance-tp5828841p5829111.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Schäfer 2014-12-03 16:25:41 Re: Auto vacuum not running -- Could not bind socket for statistics collector
Previous Message Tom Lane 2014-12-03 16:04:04 Re: Auto vacuum not running -- Could not bind socket for statistics collector