Re: String Similarity

Started by Martijn van Oosterhoutover 19 years ago2 messages
#1Martijn van Oosterhout
kleptog@svana.org

On Fri, May 19, 2006 at 04:00:48PM -0400, Mark Woodward wrote:

(3) Is there also a desire for a Levenshtein distence function for text
and varchars? I experimented with it, and was forced to write the function
in item #1.

Postgres already has a Levenshtein distence function, see fuzzystrmatch
in contrib. Whatever you come up with might fit in well there...

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

Show quoted text

From each according to his ability. To each according to his ability to litigate.

#2Andrew Dunstan
andrew@dunslane.net
In reply to: Martijn van Oosterhout (#1)

Mark Woodward wrote:

(3) Is there also a desire for a Levenshtein distence function for text
and varchars? I experimented with it, and was forced to write the function
in item #1.

fuzzystrmatch in contrib already has a Levenshtein function.

cheers

andrew