Re: Full Text fuzzy search

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, bosdgresql) i think u should write a function, that's what we did in our application.

HTH

Najib.
Michael Vodep <mvodep(at)gmx(dot)net> 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

---------------------------------
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail.