开发者

Retrieving the most common keywords from a tsvector column

I'm considering adding a tsvector column to an existing table that will hold possible search terms fo开发者_开发百科r multiple columns in that same table (e.g. the tsvector column will equal to_tsvector(header || ' ' || body || ' ' || footer)). Before I decide to do so, one of my requirements is that I am able to find the most popular keywords amongst all records in the table.

Is there anything similar to tsquery that will find my the most popular keywords over all records?


Most probably the ts_stat FTS function is what you're after.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜