diff options
Diffstat (limited to 'contrib/tsearch2/sql/tsearch2.sql')
| -rw-r--r-- | contrib/tsearch2/sql/tsearch2.sql | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/contrib/tsearch2/sql/tsearch2.sql b/contrib/tsearch2/sql/tsearch2.sql index 6e8edc3fb2..745d35b73e 100644 --- a/contrib/tsearch2/sql/tsearch2.sql +++ b/contrib/tsearch2/sql/tsearch2.sql @@ -150,7 +150,15 @@ select rank(' a:1 s:2B d g'::tsvector, 'a & s'); select rank(' a:1 s:2 d g'::tsvector, 'a & s'); 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; +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; +select * from stat('select a from test_tsvector','b') order by ndoc desc, nentry desc, word; +select * from stat('select a from test_tsvector','c') order by ndoc desc, nentry desc, word; +select * from stat('select a from test_tsvector','d') order by ndoc desc, nentry desc, word; +select * from stat('select a from test_tsvector','ad') order by ndoc desc, nentry desc, word; select reset_tsearch(); select to_tsquery('default', 'skies & books'); @@ -249,7 +257,6 @@ Upon a woman s face. E. J. Pratt (1882 1964) select * from ts_debug('Tsearch module for PostgreSQL 7.3.3'); --check ordering -drop trigger tsvectorupdate on test_tsvector; insert into test_tsvector values (null, null); select a is null, a from test_tsvector order by a; |