我试图使用Postgres中的相似性函数来进行模糊文本匹配,但是每当我try 使用它时,我就会得到错误:
function similarity(character varying, unknown) does not exist
如果在文本中添加显式强制转换,则会出现以下错误:
function similarity(text, text) does not exist
我的问题是:
SELECT (similarity("table"."field"::text, %s::text)) AS "similarity", "table".* FROM "table" WHERE similarity > .5 ORDER BY "similarity" DESC LIMIT 10
我需要做些什么来启动pg_trgm吗?