aboutsummaryrefslogtreecommitdiff
path: root/contrib/test_parser/sql/test_parser.sql
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/test_parser/sql/test_parser.sql')
-rw-r--r--contrib/test_parser/sql/test_parser.sql26
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'));