summaryrefslogtreecommitdiff
path: root/contrib/tsearch2/sql
diff options
context:
space:
mode:
authorTeodor Sigaev2003-08-28 12:23:24 +0000
committerTeodor Sigaev2003-08-28 12:23:24 +0000
commit61366a950374ccbbd972288282eb203229b474de (patch)
treebbabfc5479676b3ea42174fe1aea22018a09c3ce /contrib/tsearch2/sql
parentd1031cdef2c8f0d9c7b3a1423649d90b8498808a (diff)
More accuracy works with stopwords in queries
Diffstat (limited to 'contrib/tsearch2/sql')
-rw-r--r--contrib/tsearch2/sql/tsearch2.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/contrib/tsearch2/sql/tsearch2.sql b/contrib/tsearch2/sql/tsearch2.sql
index 0c10edb6ec9..d4f1021d7d8 100644
--- a/contrib/tsearch2/sql/tsearch2.sql
+++ b/contrib/tsearch2/sql/tsearch2.sql
@@ -87,6 +87,10 @@ SELECT length(to_tsvector('default', '345 qwe@efd.r \' http://www.com/ http://ae
select to_tsquery('default', 'qwe & sKies ');
select to_tsquery('simple', 'qwe & sKies ');
select to_tsquery('default', '\'the wether\':dc & \' sKies \':BC ');
+select to_tsquery('asd&(and|fghj)');
+select to_tsquery('(asd&and)|fghj');
+select to_tsquery('(asd&!and)|fghj');
+select to_tsquery('(the|and&(i&1))&fghj');
select 'a b:89 ca:23A,64b d:34c'::tsvector @@ 'd:AC & ca';
select 'a b:89 ca:23A,64b d:34c'::tsvector @@ 'd:AC & ca:B';
select 'a b:89 ca:23A,64b d:34c'::tsvector @@ 'd:AC & ca:A';