开发者

Retrieving the most common keywords from a tsvector column

开发者 https://www.devze.com 2022-12-13 12:07 出处:网络
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_tsvec

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

精彩评论

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

关注公众号