diff options
Diffstat (limited to 'contrib/test_parser/sql/test_parser.sql')
-rw-r--r-- | contrib/test_parser/sql/test_parser.sql | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/contrib/test_parser/sql/test_parser.sql b/contrib/test_parser/sql/test_parser.sql new file mode 100644 index 00000000000..f43d4c7e09b --- /dev/null +++ b/contrib/test_parser/sql/test_parser.sql @@ -0,0 +1,26 @@ +-- +-- first, define the parser. Turn off echoing so that expected file +-- does not depend on contents of this file. +-- +SET client_min_messages = warning; +\set ECHO none +\i test_parser.sql +\set ECHO all +RESET client_min_messages; + +-- make test configuration using parser + +CREATE TEXT SEARCH CONFIGURATION testcfg (PARSER = testparser); + +ALTER TEXT SEARCH CONFIGURATION testcfg ADD MAPPING FOR word WITH simple; + +-- ts_parse + +SELECT * FROM ts_parse('testparser', 'That''s simple parser can''t parse urls like http://some.url/here/'); + +SELECT to_tsvector('testcfg','That''s my first own parser'); + +SELECT to_tsquery('testcfg', 'star'); + +SELECT ts_headline('testcfg','Supernovae stars are the brightest phenomena in galaxies', + to_tsquery('testcfg', 'stars')); |