fuzzystrmatch Extension Not Working

I am attempting to use the fuzzystrmatch extension on Neon. I ran:

CREATE EXTENSION fuzzystrmatch;

CREATE EXTENSION fuzzystrmatch;

and it ran successfully. but when I try to use the levenshtein function or any of the other functions from the extension:

SELECT levenshtein('GUMBO', 'GAMBOL');

SELECT levenshtein('GUMBO', 'GAMBOL');

I get:

ERROR:  function levenshtein(unknown, unknown) does not exist

ERROR:  function levenshtein(unknown, unknown) does not exist

am I missing a step to get the extension enabled?

2 Replies

foreign-sapphireOP•15mo ago

Never mind, it was just a branch mixup.

sensitive-blue•15mo ago

no worries, glad all's good.