accessing the words in a full text index

From: "Massa, Harald Armin" <chef(at)ghum(dot)de>
To: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: accessing the words in a full text index
Date: 2010-03-07 11:37:33
Message-ID: e3e180dc1003070337y37ca3c46g39ad3c3be3836d65@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I want to provide a "suggest word as you type" feature in an application
(like google suggest).
All the documents are - of course - stored within a PostgreSQL database,
within TEXT columns.

To provide those suggestions, I need a list of all words, together with a
number indicating the number of occurences. (to show that "fire" is more
likely for start of "fi" then "finally")

Those informations should allready be present within the Full Text Index if
I create one for that column. Also FTI should take care of transfering words
from phrases.

SO: can I access this information anyhow via SQL-functions?

Or do I have to store that information additionallly by myself in a helper
table?

Best wishes,

Harald

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
%s is too gigantic of an industry to bend to the whims of reality

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris 2010-03-07 12:18:33 Re: XML Index again
Previous Message Alban Hertroys 2010-03-07 11:11:09 Re: XML Index again