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@xxxxxxx> 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.
