Tsearch2 - list of words or phrase with count

[Michal Hlavac]

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 ][ hl****@medium13.sk ][ http://hlavki.sk ]
[ icq:94900232 ][ callto://hlavki ]

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Oleg Bartunov]

Michal,

check stat() function.
http://www.sai.msu.su/~megera/oddmus...earch_V2_Notes

apod=# select * from stat('select ti from apod') order by ndoc desc, nentry\
apod=# desc,word limit 10;
word | ndoc | nentry
--------+------+--------
year | 1283 | 2064
star | 1273 | 3908
imag | 1267 | 1967
light | 1232 | 2206
pictur | 1177 | 1442
earth | 1059 | 1798
visibl | 992 | 1259
bright | 936 | 1335
ËÏÔÏÒ | 903 | 1441
ÜÔ | 879 | 1397

Oleg
On Thu, 22 Jul 2004, Michal Hlavac wrote:

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

Regards,
Oleg
__________________________________________________ ___________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: ol**@sai.msu.su, http://www.sai.msu.su/~megera/
phone: [phone]

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org