Postgres Pro
Downloads
Home   >   mailing lists

Re: Merge rows based on Levenshtein distance - Mailing list pgsql-general

From pinker
Subject Re: Merge rows based on Levenshtein distance
Date
Msg-id 1417623242791-5829111.post@n5.nabble.com
Whole thread Raw
In response to Merge rows based on Levenshtein distance  (mongoose <akarargyris@gmail.com>)
Responses Re: Merge rows based on Levenshtein distance
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Auto vacuum not running -- Could not bind socket for statistics collector
Next
From: Tim Schäfer
Date:
Subject: Re: Auto vacuum not running -- Could not bind socket for statistics collector