PostgreSQL 8.4 no levenshtein fuzzymatching?

Question

I'm using debian squeeze package, it says function does not exist?

Answer 1

You have to install the additional module fuzzystrmatch.
In PostgreSQL 9.1 or later you can simply use CREATE EXTENSION. Run once per database:

CREATE EXTENSION fuzzystrmatch;

In PostgreSQL 8.4 on Debian Squeeze, you would run (as user postgres) the SQL script provided by the package postgresql-contrib-8.4 (install that if you haven't already):

psql mydb -f /usr/share/postgresql/8.4/contrib/fuzzystrmatch.sql