tsearch2.out

PostgreSQL7.4.6 for Linux

    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.28
(1 row)

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

select rank(' a:1 s:2 d g'::tsvector, 'a | s');
 rank 
------
 0.19
(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');
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
 yi        |   51 |     51
 pn        |   50 |     50
 rb        |   50 |     50
 ri        |   50 |     50
 rn        |   50 |     50
 ti        |   50 |     50
 tv        |   50 |     50
 um        |   50 |     50
 ut        |   50 |     50
 ya        |   50 |     50
 et        |   49 |     49
 ix        |   49 |     49
 ox        |   49 |     49
 q3        |   49 |     49
 yf        |   49 |     49
 yl        |   49 |     49
 yo        |   49 |     49
 yr        |   49 |     49
 ev        |   48 |     48
 ey        |   48 |     48
 ot        |   48 |     48
 rc        |   48 |     48
 rm        |   48 |     48
 th        |   48 |     48
 uo        |   48 |     48
 ia        |   47 |     47
 q1        |   47 |     47
 rh        |   47 |     47
 yq        |   47 |     47
 yz        |   47 |     47
 av        |   46 |     46
 im        |   46 |     46
 os        |   46 |     46
 tk        |   46 |     46
 yy        |   46 |     46
 ir        |   45 |     45
 iv        |   45 |     45
 iw        |   45 |     45
 oj        |   45 |     45
 pl        |   45 |     45
 pv        |   45 |     45
 te        |   45 |     45
 tu        |   45 |     45
 uv        |   45 |     45
 ux        |   45 |     45
 yd        |   45 |     45
 yx        |   45 |     45
 ij        |   44 |     44
 pa        |   44 |     44
 se        |   44 |     44
 tg        |   44 |     44
 ue        |   44 |     44
 yb        |   44 |     44
 yt        |   44 |     44
 if        |   43 |     43
 ik        |   43 |     43
 in        |   43 |     43
 ph        |   43 |     43
 pj        |   43 |     43
 q5        |   43 |     43
 rt        |   43 |     43
 ub        |   43 |     43
 ud        |   43 |     43
 uh        |   43 |     43
 uj        |   43 |     43
 w7        |   43 |     43
 ye        |   43 |     43
 yv        |   43 |     43
 db        |   42 |     42
 do        |   42 |     42
 id        |   42 |     42
 ie        |   42 |     42
 ii        |   42 |     42
 of        |   42 |     42
 pr        |   42 |     42
 q4        |   42 |     42
 rf        |   42 |     42
 td        |   42 |     42
 uk        |   42 |     42
 up        |   42 |     42
 yh        |   42 |     42
 yk        |   42 |     42
 io        |   41 |     41
 it        |   41 |     41
 pb        |   41 |     41
 q0        |   41 |     41
 q7        |   41 |     41
 rs        |   41 |     41
 tj        |   41 |     41
 ur        |   41 |     41
 ig        |   40 |     40
 iu        |   40 |     40
 iy        |   40 |     40
 od        |   40 |     40
 q6        |   40 |     40
 tt        |   40 |     40
 ug        |   40 |     40
 ul        |   40 |     40
 us        |   40 |     40
 uu        |   40 |     40
 uz        |   40 |     40
 ah        |   39 |     39
 ar        |   39 |     39
 as        |   39 |     39
 dl        |   39 |     39
 dt        |   39 |     39
 hk        |   39 |     39
 iq        |   39 |     39
 is        |   39 |     39
 oc        |   39 |     39
 ov        |   39 |     39
 oy        |   39 |     39
 uf        |   39 |     39
 ui        |   39 |     39
 aa        |   38 |     38
 ad        |   38 |     38
 fh        |   38 |     38
 gm        |   38 |     38
 ic        |   38 |     38
 jd        |   38 |     38
 om        |   38 |     38
 or        |   38 |     38
 oz        |   38 |     38
 pm        |   38 |     38
 q8        |   38 |     38
 sf        |   38 |     38
 sm        |   38 |     38
 sv        |   38 |     38
 uc        |   38 |     38
 ak        |   37 |     37
 aq        |   37 |     37
 di        |   37 |     37
 e4        |   37 |     37
 fi        |   37 |     37
 fx        |   37 |     37
 ha        |   37 |     37
 hp        |   37 |     37
 ih        |   37 |     37
 og        |   37 |     37
 po        |   37 |     37
 pw        |   37 |     37
 sn        |   37 |     37
 su        |   37 |     37
 sw        |   37 |     37
 w6        |   37 |     37
 yj        |   37 |     37
 yu        |   37 |     37
 ag        |   36 |     36
 am        |   36 |     36