aboutsummaryrefslogtreecommitdiff
path: root/src/backend/snowball/snowball.sql.in
blob: 28383e5c67de5a4cf66fa9316b2476609ddd4b1c (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
-- $PostgreSQL: pgsql/src/backend/snowball/snowball.sql.in,v 1.7 2010/08/19 05:57:34 petere Exp $$

-- 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_;