[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] Full Text Index Stats
From:       Oleg Bartunov <oleg () sai ! msu ! su>
Date:       2008-10-23 6:52:12
Message-ID: Pine.LNX.4.64.0810231050530.15810 () sn ! sai ! msu ! ru
[Download RAW message or body]

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

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
[prev in list] [next in list] [prev in thread] [next in thread]