diff options
| author | Teodor Sigaev <teodor@sigaev.ru> | 2005-11-21 12:27:57 +0000 |
|---|---|---|
| committer | Teodor Sigaev <teodor@sigaev.ru> | 2005-11-21 12:27:57 +0000 |
| commit | c52795d18a698d25b9cd7cd1ca9318a42b08fdb9 (patch) | |
| tree | cc126dc4449b57de52c46497dfa3e0521ec76402 /contrib/tsearch2/sql | |
| parent | b91e6ed93e066c73324e08f3321bd3ac4d774fbd (diff) | |
| download | postgresql-c52795d18a698d25b9cd7cd1ca9318a42b08fdb9.tar.gz | |
Text parser rewritten:
- supports multibyte encodings
- more strict rules for lexemes
- flex isn't used
Add:
- tsquery plainto_tsquery(text)
Function makes tsquery from plain text.
- &&, ||, !! operation for tsquery for combining
tsquery from it's parts: 'foo & bar' || 'asd' => 'foo & bar | asd'
Diffstat (limited to 'contrib/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'; |