-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 01/24/2014 01:07 PM, alexandros_e wrote: > SELECT levenshtein_less_equal('extensive', 'exhaustive',2); Did you CREATE the extension? 8<----------------------------- psql (9.3.2) Type "help" for help. iftest=# SELECT levenshtein_less_equal('extensive', 'exhaustive',2); ERROR: function levenshtein_less_equal(unknown, unknown, integer) does not exist LINE 1: SELECT levenshtein_less_equal('extensive', 'exhaustive',2); ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. iftest=# create extension fuzzystrmatch; CREATE EXTENSION iftest=# SELECT levenshtein_less_equal('extensive', 'exhaustive',2); levenshtein_less_equal - ------------------------ 3 (1 row) 8<----------------------------- psql (9.1.11) Type "help" for help. test=# create extension fuzzystrmatch; CREATE EXTENSION test=# SELECT levenshtein_less_equal('extensive', 'exhaustive',2); levenshtein_less_equal - ------------------------ 3 (1 row) 8<----------------------------- We need more specific info about how you obtained and installed the extension. Joe - -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, & 24x7 Support -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.14 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBAgAGBQJS4thcAAoJEDfy90M199hlXisP/1wnp9j4311QENBWAM23xosl JO68J4dt6LaexrG2cXYKdVZ1steTg4LG2yEPnW1ED132pqa/yt/d+xmA7TAUNHnS es3PAw45XTFbVp5/tUhBhKnx3sEkLwE5ONDH1AjHDq/gUJMPf83xYhxYuP8rcXuY 0/cGof4pINMkfA94tKnr34x+N0xoY3jfTXPzE6x8Zci+78Kpx/SiCRlylAURexza sKHmcDUqzvnaH+LzTsS1F06tybjJh/pHVNlA/TMhyV5AEfLmVDR7LpA4yVROX7Nh qw3dBciCy7Q0GVqBNVK8UZzynlGhd3m7ldUN0tDZxovP1KEo5L+5D/oXU2Piejtb Y7bJqS9nqx8xLNkQZ+Zqsj7nXhzLF9SdCumF/6q0gCCkP97+13RESMGIr/4Un4KJ Wb4L28iilRZifbvJ9LV2grLUxoZCZeJEhQqfcjiwrBNGJMRPFZ0sveEIIeHa2H8m /3UfkSyklMGkYupemLFlXTz4qD8m6giizUpbOVbEjBicIvpMwTP6ebuZjzpwI9ui DbYRcTvWeLdVUKTq8ZCUmKUuaiqgRMJWGMYA7UVKHKf3aJ+v7+F9ddXD8YLTVO6Z cVhigwR22rGmP+si4tWMu9JOVYjhuUsrlUeGHfZALmTOUbaKRQScnR+jwXSf+a9w kqNSFvwOHVxD6fIgmjgK =+GSh -----END PGP SIGNATURE----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general