tsearch2.out

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

    12 |  
     4 | [e-mail]
    12 |  
    16 | qwe-wer
    11 | qwe
    12 | -
    11 | wer
    12 |  
     1 | asdf
    12 |  
    13 | <fr>
     1 | qwer
    12 |  
     1 | jf
    12 |  
     1 | sdjk
    13 | <we hjwer <werrwe>
    12 |  
     3 | ewr1
    12 | >
    12 |  
     3 | ewri2
    12 |  
    13 | <a href="qwe<qwe>">
    12 | 

    19 | /usr/local/fff
    12 |  
    19 | /awdf/dwqe/4325
    12 |  
    19 | rewt/ewr
    12 |  
     1 | wefjn
    12 |  
    19 | /wqe-324/ewr
    12 |  
     6 | gist.h
    12 |  
     6 | gist.h.c
    12 |  
     6 | gist.c
    12 | .
    12 |  
     1 | readline
    12 |  
    20 | 4.2
    12 |  
    20 | 4.2
    12 | .
    12 |  
    20 | 4.2
    12 | ,
    12 |  
    15 | readline-4
    11 | readline
    12 | -
    20 | 4.2
    12 |  
    15 | readline-4
    11 | readline
    12 | -
    20 | 4.2
    12 | .
    12 |  
    22 | 234
    12 |  

    13 | <i <b>
    12 |  
     1 | wow
    12 |   
    12 | <
    12 |  
     1 | jqw
    12 |  
    12 | <
    12 | >
    12 |  
     1 | qwerty
(138 rows)

SELECT to_tsvector('default', '345 qwe@efd.r '' http://www.com/ http://aew.werc.ewr/?ad=qwe&dw 1aew.werc.ewr/?ad=qwe&dw 2aew.werc.ewr http://3aew.werc.ewr/?ad=qwe&dw http://4aew.werc.ewr http://5aew.werc.ewr:8100/?  ad=qwe&dw 6aew.werc.ewr:8100/?ad=qwe&dw 7aew.werc.ewr:8100/?ad=qwe&dw=%20%32 +4.0e-10 qwe qwe qwqwe 234.435 455 5.005 [e-mail] qwe-wer asdf <fr>qwer jf sdjk<we hjwer <werrwe> ewr1> ewri2 <a href="qwe<qwe>">
/usr/local/fff /awdf/dwqe/4325 rewt/ewr wefjn /wqe-324/ewr gist.h gist.h.c gist.c. readline 4.2 4.2. 4.2, readline-4.2 readline-4.2. 234 
<i <b> wow  < jqw <> qwerty');
                                                                                                                                                                                                                                                                                                                                                                                                                                               to_tsvector                                                                                                                                                                                                                                                                                                                                                                                                                                                
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 'ad':18 'dw':20 'jf':40 '234':62 '345':1 '4.2':53,54,55,58,61 '455':32 'jqw':64 'qwe':19,28,29,36 'wer':37 'wow':63 'asdf':38 'ewr1':42 'qwer':39 'sdjk':41 '5.005':33 'ewri2':43 'qwqwe':30 'wefjn':47 'gist.c':51 'gist.h':49 'qwerti':65 '234.435':31 ':8100/?':17 'qwe-wer':35 'readlin':52,57,60 'www.com':3 '+4.0e-10':27 'gist.h.c':50 'rewt/ewr':46 'qwe@efd.r':2 'readline-4':56,59 '/?ad=qwe&dw':6,9,13 '/wqe-324/ewr':48 'aew.werc.ewr':5 '1aew.werc.ewr':8 '2aew.werc.ewr':10 '3aew.werc.ewr':12 '4aew.werc.ewr':14 '5aew.werc.ewr':16 '6aew.werc.ewr':22 '7aew.werc.ewr':25 '/usr/local/fff':44 '/awdf/dwqe/4325':45 ':8100/?ad=qwe&dw':23 '[e-mail]':34 '5aew.werc.ewr:8100/?':15 ':8100/?ad=qwe&dw=%20%32':26 'aew.werc.ewr/?ad=qwe&dw':4 '1aew.werc.ewr/?ad=qwe&dw':7 '3aew.werc.ewr/?ad=qwe&dw':11 '6aew.werc.ewr:8100/?ad=qwe&dw':21 '7aew.werc.ewr:8100/?ad=qwe&dw=%20%32':24
(1 row)

SELECT length(to_tsvector('default', '345 qw'));
 length 
--------
      2
(1 row)

SELECT length(to_tsvector('default', '345 qwe@efd.r '' http://www.com/ http://aew.werc.ewr/?ad=qwe&dw 1aew.werc.ewr/?ad=qwe&dw 2aew.werc.ewr http://3aew.werc.ewr/?ad=qwe&dw http://4aew.werc.ewr http://5aew.werc.ewr:8100/?  ad=qwe&dw 6aew.werc.ewr:8100/?ad=qwe&dw 7aew.werc.ewr:8100/?ad=qwe&dw=%20%32 +4.0e-10 qwe qwe qwqwe 234.435 455 5.005 [e-mail] qwe-wer asdf <fr>qwer jf sdjk<we hjwer <werrwe> ewr1> ewri2 <a href="qwe<qwe>">
/usr/local/fff /awdf/dwqe/4325 rewt/ewr wefjn /wqe-324/ewr gist.h gist.h.c gist.c. readline 4.2 4.2. 4.2, readline-4.2 readline-4.2. 234 
<i <b> wow  < jqw <> qwerty'));
 length 
--------
     53
(1 row)

select to_tsquery('default', 'qwe & sKies '); 
  to_tsquery   
---------------
 'qwe' & 'sky'
(1 row)

select to_tsquery('simple', 'qwe & sKies '); 
   to_tsquery    
-----------------
 'qwe' & 'skies'
(1 row)

select to_tsquery('default', '''the wether'':dc & ''           sKies '':BC ');
       to_tsquery       
------------------------
 'wether':CD & 'sky':BC
(1 row)

select to_tsquery('default', 'asd&(and|fghj)');
   to_tsquery   
----------------
 'asd' & 'fghj'
(1 row)

select to_tsquery('default', '(asd&and)|fghj');
   to_tsquery   
----------------
 'asd' | 'fghj'
(1 row)

select to_tsquery('default', '(asd&!and)|fghj');
   to_tsquery   
----------------
 'asd' | 'fghj'
(1 row)

select to_tsquery('default', '(the|and&(i&1))&fghj');
  to_tsquery  
--------------
 '1' & 'fghj'
(1 row)

select 'a b:89  ca:23A,64b d:34c'::tsvector @@ 'd:AC & ca';
 ?column? 
----------
 t
(1 row)

select 'a b:89  ca:23A,64b d:34c'::tsvector @@ 'd:AC & ca:B';
 ?column? 
----------
 t
(1 row)

select 'a b:89  ca:23A,64b d:34c'::tsvector @@ 'd:AC & ca:A';
 ?column? 
----------
 t
(1 row)

select 'a b:89  ca:23A,64b d:34c'::tsvector @@ 'd:AC & ca:C';
 ?column? 
----------
 f
(1 row)

select 'a b:89  ca:23A,64b d:34c'::tsvector @@ 'd:AC & ca:CB';
 ?column? 
----------
 t
(1 row)

CREATE TABLE test_tsvector( t text, a tsvector );
\copy test_tsvector from 'data/test_tsearch.data'
SELECT count(*) FROM test_tsvector WHERE a @@ 'wr|qh';
 count 
-------
   158
(1 row)

SELECT count(*) FROM test_tsvector WHERE a @@ 'wr&qh';
 count 
-------
    17
(1 row)

SELECT count(*) FROM test_tsvector WHERE a @@ 'eq&yt';
 count 
-------
     6
(1 row)

SELECT count(*) FROM test_tsvector WHERE a @@ 'eq|yt';
 count 
-------
    98
(1 row)

SELECT count(*) FROM test_tsvector WHERE a @@ '(eq&yt)|(wr&qh)';
 count 
-------
    23
(1 row)

SELECT count(*) FROM test_tsvector WHERE a @@ '(eq|yt)&(wr|qh)';
 count 
-------
    39
(1 row)

create index wowidx on test_tsvector using gist (a);
set enable_seqscan=off;
SELECT count(*) FROM test_tsvector WHERE a @@ 'wr|qh';
 count 
-------
   158
(1 row)

SELECT count(*) FROM test_tsvector WHERE a @@ 'wr&qh';
 count 
-------
    17
(1 row)

SELECT count(*) FROM test_tsvector WHERE a @@ 'eq&yt';
 count 
-------
     6
(1 row)

SELECT count(*) FROM test_tsvector WHERE a @@ 'eq|yt';
 count 
-------
    98
(1 row)

SELECT count(*) FROM test_tsvector WHERE a @@ '(eq&yt)|(wr&qh)';
 count 
-------
    23
(1 row)

SELECT count(*) FROM test_tsvector WHERE a @@ '(eq|yt)&(wr|qh)';
 count 
-------
    39
(1 row)

select set_curcfg('default');
 set_curcfg 
------------
 
(1 row)

CREATE TRIGGER tsvectorupdate
BEFORE UPDATE OR INSERT ON test_tsvector
FOR EACH ROW EXECUTE PROCEDURE tsearch2(a, t);
SELECT count(*) FROM test_tsvector WHERE a @@ to_tsquery('345&qwerty');
 count 
-------
     0
(1 row)

INSERT INTO test_tsvector (t) VALUES ('345 qwerty');
SELECT count(*) FROM test_tsvector WHERE a @@ to_tsquery('345&qwerty');
 count 
-------
     1
(1 row)

UPDATE test_tsvector SET t = null WHERE t = '345 qwerty';
SELECT count(*) FROM test_tsvector WHERE a @@ to_tsquery('345&qwerty');
 count 
-------
     0
(1 row)

drop trigger tsvectorupdate on test_tsvector;
create function wow(text) returns text as 'select $1 || '' copyright''; ' language sql;
create trigger tsvectorupdate before update or insert on test_tsvector
for each row execute procedure tsearch2(a, wow, t);
insert into test_tsvector (t) values ('345 qwerty');
select count(*) FROM test_tsvector WHERE a @@ to_tsquery('345&qwerty');
 count 
-------
     1
(1 row)

select count(*) FROM test_tsvector WHERE a @@ to_tsquery('copyright');
 count 
-------
     1
(1 row)

select rank(' a:1 s:2C d g'::tsvector, 'a | s');
   rank    
-----------
 0.0911891
(1 row)

select rank(' a:1 s:2B d g'::tsvector, 'a | s');
   rank   
----------
 0.151982
(1 row)

select rank(' a:1 s:2 d g'::tsvector, 'a | s');
   rank    
-----------
 0.0607927
(1 row)

select rank(' a:1 s:2C d g'::tsvector, 'a & s');
   rank   
----------
 0.140153
(1 row)

select rank(' a:1 s:2B d g'::tsvector, 'a & s');
   rank   
----------
 0.198206
(1 row)

select rank(' a:1 s:2 d g'::tsvector, 'a & s');
   rank    
-----------
 0.0991032
(1 row)

insert into test_tsvector (t) values ('foo bar foo the over foo qq bar');
drop trigger tsvectorupdate on test_tsvector;
select * from stat('select a from test_tsvector') order by ndoc desc, nentry desc, word;
   word    | ndoc | nentry 
-----------+------+--------
 qq        |  109 |    109
 qt        |  102 |    102
 qe        |  100 |    100
 qh        |   98 |     98
 qw        |   98 |     98
 qa        |   97 |     97
 ql        |   94 |     94
 qs        |   94 |     94
 qi        |   92 |     92
 qr        |   92 |     92
 qj        |   91 |     91
 qd        |   87 |     87
 qz        |   87 |     87
 qc        |   86 |     86
 qn        |   86 |     86
 qv        |   85 |     85
 qo        |   84 |     84
 qy        |   84 |     84
 wp        |   84 |     84
 qf        |   81 |     81
 qk        |   80 |     80
 wt        |   80 |     80
 qu        |   79 |     79
 qg        |   78 |     78
 wb        |   78 |     78
 qx        |   77 |     77
 wr        |   77 |     77
 ws        |   73 |     73
 wy        |   73 |     73
 wa        |   72 |     72
 wf        |   70 |     70
 wg        |   70 |     70
 wi        |   70 |     70
 wu        |   70 |     70
 wc        |   69 |     69
 wj        |   69 |     69
 qp        |   68 |     68
 wh        |   68 |     68
 wv        |   68 |     68
 qb        |   66 |     66
 eu        |   65 |     65
 we        |   65 |     65
 wl        |   65 |     65
 wq        |   65 |     65
 wk        |   64 |     64
 ee        |   63 |     63
 eo        |   63 |     63
 qm        |   63 |     63
 wn        |   63 |     63
 ef        |   62 |     62
 eh        |   62 |     62
 ex        |   62 |     62
 re        |   62 |     62
 rl        |   62 |     62
 rr        |   62 |     62
 eb        |   61 |     61
 ek        |   61 |     61
 ww        |   61 |     61
 ea        |   60 |     60
 ei        |   60 |     60
 em        |   60 |     60
 eq        |   60 |     60
 ew        |   60 |     60
 ro        |   60 |     60
 rw        |   60 |     60
 tl        |   60 |     60
 eg        |   59 |     59
 en        |   59 |     59
 ez        |   59 |     59
 rj        |   59 |     59
 ry        |   59 |     59
 tw        |   59 |     59
 tx        |   59 |     59
 ej        |   58 |     58
 es        |   58 |     58
 ra        |   58 |     58
 rd        |   58 |     58
 rg        |   58 |     58
 rx        |   58 |     58
 tb        |   58 |     58
 wd        |   58 |     58
 ed        |   57 |     57
 tc        |   57 |     57
 wx        |   57 |     57
 er        |   56 |     56
 wm        |   56 |     56
 wo        |   56 |     56
 yw        |   56 |     56
 ep        |   55 |     55
 rk        |   55 |     55
 rp        |   55 |     55
 rz        |   55 |     55
 ta        |   55 |     55
 rq        |   54 |     54
 yn        |   54 |     54
 ec        |   53 |     53
 el        |   53 |     53
 ru        |   53 |     53
 rv        |   53 |     53
 tz        |   53 |     53
 un        |   53 |     53
 wz        |   53 |     53
 ys        |   53 |     53
 oe        |   52 |     52
 tn        |   52 |     52
 tq        |   52 |     52
 ty        |   52 |     52
 uq        |   52 |     52
 yg        |   52 |     52
 ym        |   52 |     52
 oi        |   51 |     51
 to        |   51 |     51