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
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 |