Thanks for the replies,
And all the functions work with levenstein and soundex? Can they also
return the percentage of similarity?
Regards
michael
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
For the others (bostgresql, posdgresql, bosdgresql) i think u should
write a function, that's what we did in our application.
contrib/pg_trgm solves it
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www
for PostgreSQL, Postgresql, postgresql u can use ilike:example: select * from table where name ilike 'postgresql'U can even try:select * from table where name ilike '%postgresql%'the '%' is for any set of caracters (like * when u are doing a shell commande)For the others (bostgresql, posdgresql, bo
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 al
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
michae