Play around contrib/tsearch2 and contrib/pg_trgm
Michael Vodep wrote:
> Hi
>
> How can i do a full text fuzzy search with PgSQL?
>
> For example: i got a text domain. I search for Postgresql
> He should return a result for 'Postgresql' if i enter following values:
> PostgreSQL, Postgresql, postgresql
> but also
> bostgresql, posdgresql, bosdgresql
>
> Is this possible?
>
> Regrads
> michael
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
--
Teodor Sigaev E-mail: teodor@sigaev.ru
WWW: http://www.sigaev.ru/