"Igal @ Lucee.org" <igal@xxxxxxxxx> writes: > I am trying to run a query which was working a few weeks ago, and it > utilizes the <<-> operator but I am getting an error: operator does not > exist text <<-> text. > If I try instead the function word_similarity() I get a similar (no pun > intended) error: function word_similarity(text, text) does not exist. > If I try to install the pg_trgm extension with `CREATE EXTENSION > pg_trgm;` I get an error: extension "pg_trgm" already exists. Seems like a likely bet is that the extension is installed in a schema that isn't in your search_path. regards, tom lane
