diff options
Diffstat (limited to 'contrib/tsearch2/sql/tsearch2.sql')
| -rw-r--r-- | contrib/tsearch2/sql/tsearch2.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/contrib/tsearch2/sql/tsearch2.sql b/contrib/tsearch2/sql/tsearch2.sql index 82a62224df9..c6c149c121a 100644 --- a/contrib/tsearch2/sql/tsearch2.sql +++ b/contrib/tsearch2/sql/tsearch2.sql @@ -363,3 +363,14 @@ select * from ts_debug('Tsearch module for PostgreSQL 7.3.3'); insert into test_tsvector values (null, null); select a is null, a from test_tsvector order by a; +drop index wowidx; +create index wowidx on test_tsvector using gin (a); +set enable_seqscan=off; + +SELECT count(*) FROM test_tsvector WHERE a @@ 'wr|qh'; +SELECT count(*) FROM test_tsvector WHERE a @@ 'wr&qh'; +SELECT count(*) FROM test_tsvector WHERE a @@ 'eq&yt'; +SELECT count(*) FROM test_tsvector WHERE a @@ 'eq|yt'; +SELECT count(*) FROM test_tsvector WHERE a @@ '(eq&yt)|(wr&qh)'; +SELECT count(*) FROM test_tsvector WHERE a @@ '(eq|yt)&(wr|qh)'; + |