Tsearch2 - list of words or phrase with count - Mailing list pgsql-general

hello,

I have table with text attribute and fulltext index...

is it possible to do query with result:

word or phrase, count

for example:
SELECT word, my_count(word) FROM table WHERE expression.

   word    |   my_count
----------|------------
  'hello'  |      3
  'bye'    |      4
  'yellow' |      1
  'blue'   |      5

thanx, hlavki

--

[ miso hlavac ][ hlavki@medium13.sk ][ http://hlavki.sk ]
[ icq:94900232 ][ callto://hlavki ]