Re: [GENERAL] accessing the words in a full text index

2010-03-07 Thread Dimitri Fontaine
"Massa, Harald Armin" writes: > 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. See pg_trgm. http://www.postgresql.org/docs/8.4/static/pgtrgm.h

[GENERAL] accessing the words in a full text index

2010-03-07 Thread Massa, Harald Armin
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 oc