aboutsummaryrefslogtreecommitdiff
path: root/contrib/test_parser/sql/test_parser.sql
blob: f43d4c7e09baada812f08f05a28cba463d7e82f0 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
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'));