diff options
| author | Teodor Sigaev <teodor@sigaev.ru> | 2006-05-02 11:28:56 +0000 |
|---|---|---|
| committer | Teodor Sigaev <teodor@sigaev.ru> | 2006-05-02 11:28:56 +0000 |
| commit | 8a3631f8d86cdd9b07c577d6e213b1fc824db255 (patch) | |
| tree | 40bcee8383d3552cba8f79e50025613fb683a72e /contrib/tsearch2/expected | |
| parent | 427c6b5b984928972e955f4477c6ba64edbb66cc (diff) | |
| download | postgresql-8a3631f8d86cdd9b07c577d6e213b1fc824db255.tar.gz | |
GIN: Generalized Inverted iNdex.
text[], int4[], Tsearch2 support for GIN.
Diffstat (limited to 'contrib/tsearch2/expected')
| -rw-r--r-- | contrib/tsearch2/expected/tsearch2.out | 39 |
1 files changed, 39 insertions, 0 deletions
diff --git a/contrib/tsearch2/expected/tsearch2.out b/contrib/tsearch2/expected/tsearch2.out index 2a60e317cd..39a95b2f70 100644 --- a/contrib/tsearch2/expected/tsearch2.out +++ b/contrib/tsearch2/expected/tsearch2.out @@ -3001,3 +3001,42 @@ select a is null, a from test_tsvector order by a; t | (514 rows) +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'; + 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) + |