tsearch2.out

PostgreSQL 8.1.4的源码 适用于Linux下的开源数据库系统

 3b        |    2 |      2
 3f        |    2 |      2
 3h        |    2 |      2
 3o        |    2 |      2
 3p        |    2 |      2
 3r        |    2 |      2
 3s        |    2 |      2
 3v        |    2 |      2
 42        |    2 |      2
 43        |    2 |      2
 4f        |    2 |      2
 4g        |    2 |      2
 4h        |    2 |      2
 4j        |    2 |      2
 4m        |    2 |      2
 4r        |    2 |      2
 4s        |    2 |      2
 4t        |    2 |      2
 4u        |    2 |      2
 5c        |    2 |      2
 5f        |    2 |      2
 5h        |    2 |      2
 5p        |    2 |      2
 5q        |    2 |      2
 5z        |    2 |      2
 6a        |    2 |      2
 6h        |    2 |      2
 6q        |    2 |      2
 6r        |    2 |      2
 6t        |    2 |      2
 6y        |    2 |      2
 70        |    2 |      2
 7c        |    2 |      2
 7g        |    2 |      2
 7k        |    2 |      2
 7o        |    2 |      2
 7u        |    2 |      2
 8j        |    2 |      2
 8w        |    2 |      2
 9f        |    2 |      2
 9y        |    2 |      2
 copyright |    2 |      2
 foo       |    1 |      3
 bar       |    1 |      2
 0e        |    1 |      1
 0h        |    1 |      1
 0p        |    1 |      1
 0w        |    1 |      1
 0z        |    1 |      1
 11        |    1 |      1
 13        |    1 |      1
 14        |    1 |      1
 17        |    1 |      1
 1k        |    1 |      1
 1q        |    1 |      1
 1z        |    1 |      1
 24        |    1 |      1
 26        |    1 |      1
 28        |    1 |      1
 2f        |    1 |      1
 30        |    1 |      1
 345       |    1 |      1
 37        |    1 |      1
 39        |    1 |      1
 3a        |    1 |      1
 3e        |    1 |      1
 3g        |    1 |      1
 3i        |    1 |      1
 3m        |    1 |      1
 3t        |    1 |      1
 3u        |    1 |      1
 40        |    1 |      1
 41        |    1 |      1
 44        |    1 |      1
 45        |    1 |      1
 48        |    1 |      1
 4b        |    1 |      1
 4c        |    1 |      1
 4i        |    1 |      1
 4k        |    1 |      1
 4n        |    1 |      1
 4o        |    1 |      1
 4q        |    1 |      1
 4w        |    1 |      1
 4y        |    1 |      1
 51        |    1 |      1
 55        |    1 |      1
 56        |    1 |      1
 5a        |    1 |      1
 5d        |    1 |      1
 5g        |    1 |      1
 5j        |    1 |      1
 5l        |    1 |      1
 5s        |    1 |      1
 5u        |    1 |      1
 5x        |    1 |      1
 64        |    1 |      1
 68        |    1 |      1
 6c        |    1 |      1
 6f        |    1 |      1
 6g        |    1 |      1
 6i        |    1 |      1
 6k        |    1 |      1
 6n        |    1 |      1
 6p        |    1 |      1
 6s        |    1 |      1
 6u        |    1 |      1
 6x        |    1 |      1
 72        |    1 |      1
 7f        |    1 |      1
 7j        |    1 |      1
 7n        |    1 |      1
 7p        |    1 |      1
 7w        |    1 |      1
 7y        |    1 |      1
 7z        |    1 |      1
 80        |    1 |      1
 82        |    1 |      1
 85        |    1 |      1
 8d        |    1 |      1
 8i        |    1 |      1
 8l        |    1 |      1
 8n        |    1 |      1
 8p        |    1 |      1
 8t        |    1 |      1
 8x        |    1 |      1
 95        |    1 |      1
 97        |    1 |      1
 9a        |    1 |      1
 9e        |    1 |      1
 9h        |    1 |      1
 9r        |    1 |      1
 9w        |    1 |      1
 qwerti    |    1 |      1
(1146 rows)

insert into test_tsvector values ('1', 'a:1a,2,3b b:5a,6a,7c,8');
insert into test_tsvector values ('1', 'a:1a,2,3c b:5a,6b,7c,8b');
select * from stat('select a from test_tsvector','a') order by ndoc desc, nentry desc, word;
 word | ndoc | nentry 
------+------+--------
 b    |    2 |      3
 a    |    2 |      2
(2 rows)

select * from stat('select a from test_tsvector','b') order by ndoc desc, nentry desc, word;
 word | ndoc | nentry 
------+------+--------
 b    |    1 |      2
 a    |    1 |      1
(2 rows)

select * from stat('select a from test_tsvector','c') order by ndoc desc, nentry desc, word;
 word | ndoc | nentry 
------+------+--------
 b    |    2 |      2
 a    |    1 |      1
(2 rows)

select * from stat('select a from test_tsvector','d') order by ndoc desc, nentry desc, word;
   word    | ndoc | nentry 
-----------+------+--------
 a         |    2 |      2
 copyright |    2 |      2
 foo       |    1 |      3
 bar       |    1 |      2
 345       |    1 |      1
 b         |    1 |      1
 qq        |    1 |      1
 qwerti    |    1 |      1
(8 rows)

select * from stat('select a from test_tsvector','ad') order by ndoc desc, nentry desc, word;
   word    | ndoc | nentry 
-----------+------+--------
 a         |    2 |      4
 b         |    2 |      4
 copyright |    2 |      2
 foo       |    1 |      3
 bar       |    1 |      2
 345       |    1 |      1
 qq        |    1 |      1
 qwerti    |    1 |      1
(8 rows)

select reset_tsearch();
NOTICE:  TSearch cache cleaned
 reset_tsearch 
---------------
 
(1 row)

select to_tsquery('default', 'skies & books');
   to_tsquery   
----------------
 'sky' & 'book'
(1 row)

select rank_cd(to_tsvector('Erosion It took the sea a thousand years,
A thousand years to trace
The granite features of this cliff
In crag and scarp and base.
It took the sea an hour one night
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
(1 row)

select rank_cd(to_tsvector('Erosion It took the sea a thousand years,
A thousand years to trace
The granite features of this cliff
In crag and scarp and base.
It took the sea an hour one night
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
(1 row)

select rank_cd(to_tsvector('Erosion It took the sea a thousand years,
A thousand years to trace
The granite features of this cliff
In crag and scarp and base.
It took the sea an hour one night
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'));
 rank_cd 
---------
       2
(1 row)

select get_covers(to_tsvector('Erosion It took the sea a thousand years,
A thousand years to trace
The granite features of this cliff
In crag and scarp and base.
It took the sea an hour one night
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'));
                                                                                             get_covers                                                                                             
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 eros took {1 sea thousand year }1 {2 thousand year trace granit featur cliff crag scarp base took sea }2 hour one night hour storm place sculptur granit seam upon woman face e j pratt 1882 1964 
(1 row)

select get_covers(to_tsvector('Erosion It took the sea a thousand years,
A thousand years to trace
The granite features of this cliff
In crag and scarp and base.
It took the sea an hour one night
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'));
                                                                                                get_covers                                                                                                
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 eros took {1 sea thousand year thousand year trace {2 granit }1 featur cliff crag scarp base took {3 sea }2 hour one night hour storm place sculptur granit }3 seam upon woman face e j pratt 1882 1964 
(1 row)

select get_covers(to_tsvector('Erosion It took the sea a thousand years,
A thousand years to trace
The granite features of this cliff
In crag and scarp and base.
It took the sea an hour one night
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'));
                                                                                             get_covers                                                                                             
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 eros took {1 sea }1 thousand year thousand year trace granit featur cliff crag scarp base took {2 sea }2 hour one night hour storm place sculptur granit seam upon woman face e j pratt 1882 1964 
(1 row)

select headline('Erosion It took the sea a thousand years,
A thousand years to trace
The granite features of this cliff
In crag and scarp and base.
It took the sea an hour one night
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'));
                                                       headline                                                        
-----------------------------------------------------------------------------------------------------------------------
 <b>sea</b> a <b>thousand</b> <b>years</b>,
A <b>thousand</b> <b>years</b> to trace
The granite features of this cliff
(1 row)

 
select headline('Erosion It took the sea a thousand years,
A thousand years to trace
The granite features of this cliff
In crag and scarp and base.
It took the sea an hour one night
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'));
                                             headline                                             
--------------------------------------------------------------------------------------------------
 <b>sea</b> a thousand years,
A thousand years to trace
The <b>granite</b> features of this cliff
(1 row)

 
select headline('Erosion It took the sea a thousand years,
A thousand years to trace
The granite features of this cliff
In crag and scarp and base.
It took the sea an hour one night
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'));
                                         headline                                          
-------------------------------------------------------------------------------------------
 <b>sea</b> a thousand years,
A thousand years to trace
The granite features of this cliff
(1 row)

select headline('
<html>
<!-- some comment -->
<body>
Sea view wow <u>foo bar</u> <i>qq</i>
<a href="http://www.google.com/foo.bar.html" target="_blank">YES &nbsp;</a>
ff-bg
<script>
	document.write(15);
</script>
</body>
</html>', 
to_tsquery('sea&foo'), 'HighlightAll=true');
                                                                                                              headline                                                                                                               
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 
<html>
<!-- some comment -->
<body>
<b>Sea</b> view wow <u><b>foo</b> bar</u> <i>qq</i>
<a href="http://www.google.com/foo.bar.html" target="_blank">YES &nbsp;</a>
 ff-bg
<script>
	document.write(15);
</script>
</body>
</html>
(1 row)

--check debug
select * from ts_debug('Tsearch module for PostgreSQL 7.3.3');
 ts_name | tok_type | description |   token    | dict_name |   tsvector   
---------+----------+-------------+------------+-----------+--------------
 default | lword    | Latin word  | Tsearch    | {en_stem} | 'tsearch'
 default | lword    | Latin word  | module     | {en_stem} | 'modul'
 default | lword    | Latin word  | for        | {en_stem} | 
 default | lword    | Latin word  | PostgreSQL | {en_stem} | 'postgresql'
 default | version  | VERSION     | 7.3.3      | {simple}  | '7.3.3'
(5 rows)

--check ordering
insert into test_tsvector values (null, null);
select a is null, a from test_tsvector order by a;
 ?column? |                                                                                                                                                                                                                                                                              a                                                                                                                                                                                                                                                                              
----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 f        | 
 f        | 
 f        | 
 f        | 
 f        | 
 f        | 
 f        | 
 f        | 
 f        | 
 f        | '345':1 'qwerti':2 'copyright':3
 f        | 'qq':7 'bar':2,8 'foo':1,3,6 'copyright':9
 f        | 'a':1A,2,3C 'b':5A,6B,7C,8B
 f        | 'a':1A,2,3B 'b':5A,6A,7C,8
 f        | '7w' 'ch' 'd7' 'eo' 'gw' 'i4' 'lq' 'o6' 'qt' 'y0'
 f        | 'ar' 'ei' 'kq' 'ma' 'qa' 'qh' 'qq' 'qz' 'rx' 'st'
 f        | 'gs' 'i6' 'i9' 'j2' 'l0' 'oq' 'qx' 'sc' 'xe' 'yu'
 f        | 'ap' 'i2' 'k0' 'n4' 'ou' 'px' 'qe' 'qo' 'qr' 't1' 'yz'
 f        | 'cb' 'ib' 'ih' 'jx' 'oy' 'ph' 'tl' 'ty' 'vb' 'vu' 'wu'
 f        | 'cp' 'i0' 'ia' 'jh' 'kh' 'kl' 'ql' 'sb' 'u3' 'wy' 'ys'
 f        | 'cy' 'ey' 'gr' 'lq' 'n1' 'pp' 'pq' 'qb' 'qe' 'se' 'wb'
 f        | 'ja' 'k2' 'ko' 'o6' 'ob' 'ps' 't9' 'tz' 'uk' 'um' 'vv'
 f        | '5e' 'a2' 'ag' 'ay' 'dc' 'ef' 'jd' 'mn' 'pl' 'qp' 'wu' 'xd'
 f        | '7a' 'ap' 'bl' 'fl' 'g7' 'ko' 'ma' 'qi' 'ri' 'rp' 'y5' 'yo'
 f        | 'a4' 'an' 'go' 'ki' 'px' 'qq' 'td' 'tm' 'ur' 'wc' 'wp' 'yx'
 f        | 'aa' 'ah' 'bo' 'dz' 'pd' 'pm' 'qf' 'qw' 'rd' 'rn' 'tf' 'wu'
 f        | 'aj' 'ar' 'ay' 'eb' 'g5' 'ic' 'la' 'u2' 'up' 'wb' 'x8' 'yr'
 f        | 'aw' 'dz' 'el' 'hb' 'iu' 'lc' 'm9' 'r5' 'rt' 'uz' 'x2' 'zp'
 f        | 'dz' 'ea' 'h8' 'j9' 'mr' 'pc' 'qa' 'qt' 'rm' 'rv' 'ub' 'wg'
 f        | 'ew' 'fi' 'g2' 'ku' 'od' 'pk' 'tm' 'tq' 'tu' 'uf' 'wn' 'y1'
 f        | 'gi' 'n3' 'n7' 'om' 'qa' 'r7' 're' 'ug' 'w7' 'wi' 'x4' 'yn'
 f        | '3k' 'f5' 'if' 'kg' 'lj' 'ol' 'qr' 'so' 'ta' 'u1' 'vu' 'wr' 'y2'
 f        | '70' 'e0' 'ep' 'ex' 'hh' 'jn' 'kg' 'nq' 'rg' 'rj' 'uf' 'vs' 'ys'
 f        | 'ag' 'al' 'ay' 'fw' 'hi' 'ou' 'p6' 'qy' 'rg' 'rz' 'sx' 'uy' 'zb'
 f        | 'cm' 'dm' 'eh' 'em' 'ik' 'j0' 'kk' 'lp' 'ng' 'or' 'pu' 'qd' 'tw'
 f        | 'di' 'ec' 'i4' 'iq' 'iw' 'ko' 'l3' 'mw' 'py' 'qo' 'rx' 'wt' 'yl'
 f        | '5q' 'av' 'd2' 'd4' 'e5' 'jc' 'km' 'mm' 'pa' 'rs' 's4' 'si' 'tc' 'ut'
 f        | '6o' 'av' 'ed' 'ee' 'gf' 'ii' 'o8' 'og' 'om' 'qs' 'ta' 'th' 'tk' 'w0'
 f        | '7y' 'aq' 'cu' 'd3' 'h2' 'ih' 'oc' 'qh' 'rc' 'rs' 't3' 'ud' 'we' 'zt'
 f        | 'b7' 'eu' 'g4' 'hw' 'in' 'pi' 'qt' 'r0' 'rg' 'sn' 'sz' 'tc' 'wd' 'zs'
 f        | 'fb' 'in' 'iy' 'lu' 'p4' 'pd' 'qa' 'qq' 's6' 'ta' 'y1' 'yg' 'yy' 'zk'
 f        | 'at' 'ec' 'hs' 'ix' 'ks' 'lq' 'ls' 'pk' 'qs' 'qy' 'rc' 'ut' 'xv' 'yo' 'ys'
 f        | 'az' 'bl' 'dl' 'ec' 'gg' 'jq' 'o0' 'oj' 'q8' 'qq' 'ta' 'un' 'wb' 'wo' 'xu'
 f        | 'c0' 'd4' 'dw' 'ef' 'em' 'j2' 'kj' 'ql' 'rn' 'ta' 'uk' 'vv' 'wf' 'y9' 'zq'
 f        | 'gn' 'gx' 'hf' 'ji' 'kx' 'nh' 'o6' 'pe' 'q1' 'qt' 'rw' 'sc' 'ss' 'yh' 'zm'
 f        | 'h7' 'in' 'is' 'o7' 'q0' 'qa' 'qq' 'rl' 'rs' 'tu' 'u9' 'v3' 'vr' 'yq' 'zy'
 f        | 'ae' 'af' 'ay' 'da' 'dp' 'dq' 'e1' 'gi' 'gk' 'rl' 'sf' 'ta' 'td' 'tf' 'tt' 'tw'
 f        | 'aj' 'cl' 'cy' 'ee' 'i3' 'ir' 'nx' 'oz' 'qm' 'qw' 'r2' 't2' 'u0' 'ub' 'ur' 'wj'
 f        | 'av' 'dp' 'ff' 'fx' 'jk' 'ke' 'lb' 'lm' 'n1' 'ql' 'rv' 's4' 'uv' 'wl' 'ws' 'yj'
 f        | 'b8' 'eh' 'g5' 'gn' 'jo' 'mx' 'og' 'ol' 'on' 'px' 'rr' 'sl' 'un' 'uz' 'wv' 'yf'
 f        | 'bt' 'dy' 'gy' 'hg' 'i7' 'it' 'jv' 'lh' 'ox' 'qo' 'ri' 's3' 'ss' 'u1' 'uq' 'wr'
 f        | 'ef' 'ej' 'fn' 'ho' 'ia' 'il' 'iq' 'mj' 'nr' 'p5' 'rm' 'sd' 'ux' 'vi' 'wq' 'y6'
 f        | '25' 'cd' 'd2' 'dv' 'eo' 'es' 'f4' 'oc' 'qc' 'sh' 'te' 'tv' 'wd' 'wn' 'wo' 'xp' 'zt'
 f        | '2y' '8i' 'by' 'dl' 'h6' 'hj' 'm3' 'ml' 'qa' 'qx' 'r1' 'rm' 'rn' 'u4' 'uj' 'wo' 'xv'
 f        | 'ad' 'bs' 'dx' 'fi' 'i5' 'ia' 'j3' 'm5' 'mn' 'nr' 'ox' 'tg' 'un' 'vo' 'wj' 'wt' 'ys'
 f        | 'am' 'hw' 'jd' 'na' 'oe' 'pw' 'ql' 'qr' 's9' 'sk' 'u7' 'wa' 'wg' 'wu' 'x6' 'xr' 'yf'
 f        | 'de' 'mc' 'q1' 'q8' 'qp' 'qt' 'rq' 'rv' 'sa' 'sn' 'u8' 'vs' 'w9' 'wo' 'wp' 'ww' 'yl'
 f        | 'aa' 'af' 'ee' 'hb' 'ih' 'j2' 'lv' 'mw' 'pp' 'q3' 'rd' 'tb' 'td' 'ua' 'ug' 'up' 'xh' 'yy'
 f        | 'an' 'cp' 'dq' 'ej' 'ez' 'lj' 'ln' 'nu' 'qy' 'sm' 't8' 'td' 'tg' 'us' 'uw' 'vn' 'y4' 'z9'
 f        | 'ca' 'do' 'h5' 'i9' 'io' 'jk' 'jl' 'kn' 'qq' 'tm' 'ul' 'w9' 'wb' 'wp' 'wt' 'wx' 'y3' 'zd'
 f        | '16' 'ae' 'al' 'ef' 'eg' 'ew' 'gi' 'ha' 'id' 'ng' 'o3' 'on' 'p9' 'rz' 'uf' 'vg' 'wo' 'wr' 'zh'
 f        | 'ca' 'fu' 'hv' 'la' 'mt' 'ov' 'pl' 'q8' 'r3' 'sp' 'sy' 'tg' 'to' 'tv' 'wn' 'x4' 'yh' 'yp' 'ze'
 f        | 'cv' 'ds' 'dx' 'dy' 'ex' 'hh' 'lf' 'mq' 'qe' 'qu' 'rb' 'tb' 'tv' 'tz' 'ue' 'ui' 'wi' 'yb' 'zz'
 f        | 'ec' 'fd' 'gm' 'it' 'iu' 'kx' 'l1' 'pi' 'q1' 'qe' 'qs' 'ra' 'ri' 'rp' 'tn' 'to' 'vx' 'wh' 'wl'
 f        | 'eq' 'g7' 'jc' 'jf' 'ji' 'lw' 'ma' 'oe' 'p7' 'qb' 'qj' 'qo' 'u7' 'v7' 'w3' 'wd' 'wz' 'xg' 'yr'
 f        | 'a2' 'cs' 'ee' 'em' 'gk' 'hv' 'iy' 'kq' 'nc' 'pb' 'q5' 'qy' 'rq' 'rr' 'ts' 'uq' 'vt' 'w0' 'y6' 'yz'
 f        | 'al' 'fh' 'fk' 'gy' 'he' 'ie' 'iz' 'lq' 'oh' 'pu' 'q7' 's6' 'sd' 'sr' 'sw' 'uu' 'uz' 'v6' 'ws' 'xo'
 f        | 'aw' 'bm' 'dw' 'e5' 'ht' 'j4' 'kv' 'm5' 'oi' 'qa' 'qe' 'qf' 'ri' 'rj' 't6' 't8' 'un' 'wc' 'yb' 'yj'
 f        | 'az' 'bl' 'bo' 'cf' 'gt' 'h0' 'hx' 'iq' 'k2' 'kb' 'oc' 'qg' 'qn' 'qz' 're' 'rl' 'rv' 'xp' 'y8' 'yf'
 f        | 'bj' 'dq' 'e2' 'ec' 'fs' 'g8' 'gd' 'iw' 'jt' 'nn' 'ns' 'o9' 'p0' 'tb' 'u7' 'uv' 'wf' 'wr' 'xf' 'z3'
 f        | 'bs' 'ee' 'gz' 'hv' 'ib' 'kc' 'lb' 'nu' 'ps' 'pt' 'qh' 'ud' 'vo' 'vq' 'vu' 'wb' 'wj' 'x3' 'xu' 'yf'
 f        | '2o' 'a5' 'cg' 'ch' 'cp' 'eb' 'eg' 'eh' 'e