我运行了以下查询:
SELECT
*
FROM
(
SELECT
ts_rank(document, to_tsquery('idis:*')) AS qrank,
public.tbl_company.company_name as name,
public.tbl_company.document as vector,
to_tsquery('idis:*') as query
FROM
public.tbl_company
WHERE
public.tbl_company.document @@to_tsquery('idis:*')
UNION
SELECT
ts_rank(document, to_tsquery('idis:*')) AS qrank,
public.tbl_person.full_name as name,
public.tbl_person.document as vector,
to_tsquery('idis:*') as query
FROM
public.tbl_person
WHERE
public.tbl_person.document @@to_tsquery('idis:*')
)as customers
ORDER BY qrank DESC我收到了以下结果:

我搜索了一个文本作为'idis‘,但是ts_query删除了's’字符并搜索了'idi‘。结果按idil greather的等级和等级排序。
为什么ts_query删除了最后一个字符?我如何解决这个问题?
https://stackoverflow.com/questions/44454151
复制相似问题