Thread: Full Text Index Stats

<div class="Section1"><p class="MsoNormal">Greetings,<p class="MsoNormal"> <p class="MsoNormal">I couldn’t find
anythingabout this in the documentation or the mailing list archives, so forgive me if this has already been
addressed. <p class="MsoNormal"> <p class="MsoNormal">I’m trying to determine if the full text indexing has any
built-incapability for providing information about word occurrence, i.e. the number of times a given word is used.  I
readabout the ts_stat function, but either I don’t understand the syntax well enough or I don’t think this is what I’m
lookingfor.  I know it can be used for determining the most used words in the index (although this is very slow), but I
wantto be able to get the number of occurrences on a given word.    Is that kind of thing built in somewhere or do I
needto write it myself?<p class="MsoNormal"> <p class="MsoNormal">Thanks!</div> 

Ryan,

you may take a look on 
http://www.sai.msu.su/~megera/postgres/talks/fts84+.pdf
There are slides with examples

Oleg
On Mon, 20 Oct 2008, Ryan Hansen wrote:

> Greetings,
>
>
>
> I couldn't find anything about this in the documentation or the mailing list
> archives, so forgive me if this has already been addressed.
>
>
>
> I'm trying to determine if the full text indexing has any built-in
> capability for providing information about word occurrence, i.e. the number
> of times a given word is used.  I read about the ts_stat function, but
> either I don't understand the syntax well enough or I don't think this is
> what I'm looking for.  I know it can be used for determining the most used
> words in the index (although this is very slow), but I want to be able to
> get the number of occurrences on a given word.    Is that kind of thing
> built in somewhere or do I need to write it myself?
>
>
>
> Thanks!
>
>
    Regards,        Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83