Re: full text index and most frequently used words - Mailing list pgsql-general

> What I'd like to know is if there is an easy to way to use the full
> text index to generate a list of the most common words.  I could write
> this code manually, but I'm hoping there's a better (simpler) way.

For 8.3
http://www.postgresql.org/docs/8.3/static/textsearch-features.html#TEXTSEARCH-STATISTICS

For versions before 8.3 just use stat() function instead of ts_stat().
--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/