Tsearch2 - list of words or phrase with count

From: Michal Hlavac <hlavki(at)medium13(dot)sk>
To: pgsql-general(at)postgresql(dot)org
Subject: Tsearch2 - list of words or phrase with count
Date: 2004-07-22 08:02:19
Message-ID: 40FF748B.8070800@medium13.sk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)medium13(dot)sk ][ http://hlavki.sk ]
[ icq:94900232 ][ callto://hlavki ]

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2004-07-22 09:32:10 Re: Tsearch2 - list of words or phrase with count
Previous Message Kevin Macdonald 2004-07-22 04:34:26 Table access method not behaving like Oracle (index vs sequential scan). Examples and stats provided.