Previous | Next |
Function statFor a tsvector column in a table, returns the distinct words along with their frequency. This includes the number of documents (table rows) containing a word and the number of entries for a word which includes multiple occurrences within a row. stat(txt TEXT) RETURNS SETOF STATINFO
SELECT * FROM stat('SELECT ts_vec FROM ts_readme') ORDER BY ndoc desc, word LIMIT 5; word | ndoc | nentry ----------+------+-------- tsearch | 18 | 21 document | 17 | 19 search | 17 | 17 index | 15 | 15 use | 15 | 15 (5 rows) |