Re: Fuzzy matching?
От | Joe Conway |
---|---|
Тема | Re: Fuzzy matching? |
Дата | |
Msg-id | 03d501c119eb$91c23f40$48d210ac@jecw2k1 обсуждение исходный текст |
Ответ на | Fuzzy matching? ("Josh Berkus" <josh@agliodbs.com>) |
Ответы |
Re: Fuzzy matching?
Re: Fuzzy matching? Re: Fuzzy matching? |
Список | pgsql-sql |
> > Sounds like you want something along the lines of soundex or metaphone? I > > don't see either function in PostgreSQL, but take a look at the PHP manual > > to see examples: http://www.php.net/manual/en/function.soundex.php , > > http://www.php.net/manual/en/function.metaphone.php > > > > See /contrib/soundex. Sorry, missed that -- I only looked in the Documentation :( I guess it's not there because it is a contrib. FWIW, both Oracle and MSSQL have a built-in soundex function. In any case, metaphone is reportedly more accurate (at least for English words) than soundex, and levenshtein offers an entirely different and interesting approach. Any interest in having all three of these in the backend? -- Joe
В списке pgsql-sql по дате отправления: