aboutsummaryrefslogtreecommitdiff
path: root/src/backend/snowball/snowball.sql.in
blob: 2f68393ab5bb732dfc5ddf740eb1a8d9bf3740c1 (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
-- src/backend/snowball/snowball.sql.in$

-- text search configuration for _LANGNAME_ language
CREATE TEXT SEARCH DICTIONARY _DICTNAME_
	(TEMPLATE = snowball, Language = _LANGNAME_ _STOPWORDS_);

COMMENT ON TEXT SEARCH DICTIONARY _DICTNAME_ IS 'snowball stemmer for _LANGNAME_ language';

CREATE TEXT SEARCH CONFIGURATION _CFGNAME_
	(PARSER = default);

COMMENT ON TEXT SEARCH CONFIGURATION _CFGNAME_ IS 'configuration for _LANGNAME_ language';

ALTER TEXT SEARCH CONFIGURATION _CFGNAME_ ADD MAPPING
	FOR email, url, url_path, host, file, version,
	    sfloat, float, int, uint,
	    numword, hword_numpart, numhword
	WITH simple;

ALTER TEXT SEARCH CONFIGURATION _CFGNAME_ ADD MAPPING
    FOR asciiword, hword_asciipart, asciihword
	WITH _ASCDICTNAME_;

ALTER TEXT SEARCH CONFIGURATION _CFGNAME_ ADD MAPPING
    FOR word, hword_part, hword
	WITH _NONASCDICTNAME_;