diff options
Diffstat (limited to 'contrib/tsearch2/sql/tsearch2.sql')
| -rw-r--r-- | contrib/tsearch2/sql/tsearch2.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/contrib/tsearch2/sql/tsearch2.sql b/contrib/tsearch2/sql/tsearch2.sql index 0923ce7a19..bd0baa3b41 100644 --- a/contrib/tsearch2/sql/tsearch2.sql +++ b/contrib/tsearch2/sql/tsearch2.sql @@ -173,6 +173,13 @@ select to_tsquery('default', 'asd&(and|fghj)'); select to_tsquery('default', '(asd&and)|fghj'); select to_tsquery('default', '(asd&!and)|fghj'); select to_tsquery('default', '(the|and&(i&1))&fghj'); + +select plainto_tsquery('default', 'the and z 1))& fghj'); +select plainto_tsquery('default', 'foo bar') && plainto_tsquery('default', 'asd'); +select plainto_tsquery('default', 'foo bar') || plainto_tsquery('default', 'asd fg'); +select plainto_tsquery('default', 'foo bar') || !!plainto_tsquery('default', 'asd fg'); +select plainto_tsquery('default', 'foo bar') && 'asd | fg'; + 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'; |