CODEWITHSUNDEEP
postgresqlfull-text-searchtrigram
Mehul
Mehul

Reputation: 19

Problem in using pg_trgm PostgreSQL - function similarity(tsvector, unknown) does not exist

I am using PostgreSQL for FTS features. I am working on partial word search and I want to use trigram based matching.

I have executed following queries.

CREATE EXTENSION pg_trgm SCHEMA schema_name;
SELECT SIMILARITY ('Sensor Values', 'sensor');

Error message:

ERROR:  function similarity(unknown, unknown) does not exist
LINE 1: SELECT SIMILARITY ('Sensor Values', 'sensor');
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SQL state: 42883
Character: 8

I am not sure how I can solve mentioned error. I am using PostgreSQL 14.5 and PG ADMIN 4 (6.12) on windows machine.

Do I need to set some path to use all Tri gram functions?

Upvotes: 0

Views: 642

Answers (0)

Related Questions