diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2007-10-15 21:36:50 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2007-10-15 21:36:50 +0000 |
commit | 5fcb079858bb392e87067b5526e9df950db38024 (patch) | |
tree | 4ffb764af092be94fbe0e033dce2f492e6c937f7 /contrib/test_parser/sql/test_parser.sql | |
parent | fb631dba2a3c2c183bb99f2098491ecf96fb6664 (diff) | |
download | postgresql-5fcb079858bb392e87067b5526e9df950db38024.tar.gz postgresql-5fcb079858bb392e87067b5526e9df950db38024.zip |
Add sample text search dictionary templates and parsers, to replace the
hard-to-maintain textual examples currently in the SGML docs. From
Sergey Karpov.
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')); |