On 01/24/2014 01:07 PM, alexandros_e wrote:
Query: 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. Even this: SELECT levenshtein_less_equal('extensive'::TEXT, 'exhaustive'::TEXT,2::INTEGER); function levenshtein_less_equal(text, text, integer) does not exist But this works perfectly: SELECT levenshtein('extensive', 'exhaustive'); 4
Are you sure you are connecting to a 9.1 server? levenshtein_less_equal does not exist in 9.0- which would result in that error.
When you are in psql what does: SELECT version(); and \df levenshtein_less_equal show?
-- View this message in context: http://postgresql.1045698.n5.nabble.com/levenshtein-less-equal-does-not-work-tp5788710p5788713.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general