summaryrefslogtreecommitdiff
path: root/contrib/tsearch2/expected
diff options
context:
space:
mode:
authorTeodor Sigaev <teodor@sigaev.ru>2006-03-02 19:07:19 +0000
committerTeodor Sigaev <teodor@sigaev.ru>2006-03-02 19:07:19 +0000
commit38c4fe87ac86965253235edf46a5908e49c8478e (patch)
tree51b68da465c5c0a314594cc2e583de2673a63eea /contrib/tsearch2/expected
parent85fa9f516c6e1d0fd30303a7cf1b182e1d7d69d9 (diff)
downloadpostgresql-38c4fe87ac86965253235edf46a5908e49c8478e.tar.gz
Significantly improve ranking:
1) rank_cd now use weight of lexemes 2) rank_cd and rank can use any combination of normalization methods: no normalization normalization by log(length of document) -----/------- by length of document -----/------- by number of unique word in document -----/------- by log(number of unique word in document) -----/------- by number of covers (only rank_cd) Improve cover's search. TODO: changes in documentation
Diffstat (limited to 'contrib/tsearch2/expected')
-rw-r--r--contrib/tsearch2/expected/tsearch2.out14
1 files changed, 7 insertions, 7 deletions
diff --git a/contrib/tsearch2/expected/tsearch2.out b/contrib/tsearch2/expected/tsearch2.out
index 8fb16b045d..2a60e317cd 100644
--- a/contrib/tsearch2/expected/tsearch2.out
+++ b/contrib/tsearch2/expected/tsearch2.out
@@ -2315,9 +2315,9 @@ An hour of storm to place
The sculpture of these granite seams,
Upon a woman s face. E. J. Pratt (1882 1964)
'), to_tsquery('sea&thousand&years'));
- rank_cd
----------
- 1.2
+ rank_cd
+-----------
+ 0.0555556
(1 row)
select rank_cd(to_tsvector('Erosion It took the sea a thousand years,
@@ -2329,9 +2329,9 @@ An hour of storm to place
The sculpture of these granite seams,
Upon a woman s face. E. J. Pratt (1882 1964)
'), to_tsquery('granite&sea'));
- rank_cd
-----------
- 0.880303
+ rank_cd
+-----------
+ 0.0238095
(1 row)
select rank_cd(to_tsvector('Erosion It took the sea a thousand years,
@@ -2345,7 +2345,7 @@ Upon a woman s face. E. J. Pratt (1882 1964)
'), to_tsquery('sea'));
rank_cd
---------
- 2
+ 0.2
(1 row)
select get_covers(to_tsvector('Erosion It took the sea a thousand years,