I would like to know if I can do a similarity lookup in a field of type character varying
in PostgreSql.
For example: The name I have written to the table in the name field is Tauros
and I'm looking for Taurros
. I wanted something that would return the degree of similarity between what was typed and what I found.
Remembering that I'm using version 8.4 of postgresql and I also have no way to make installations on the server, since it is from a company that I split the bank. That is, I can not use the fuzzystrmatch module, with the functions soundex()
and difference()