Обсуждение: Full Text Index Stats
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!
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