aboutsummaryrefslogtreecommitdiff
path: root/src/backend/snowball/snowball.sql.in
blob: 873a5bf5592d11497d772a90c8a3442ddac70adb (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.2 2007/08/22 01:39:44 tgl Exp $$

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

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

CREATE TEXT SEARCH CONFIGURATION _CFGNAME_
	(PARSER = default);

COMMENT ON TEXT SEARCH CONFIGURATION _CFGNAME_ IS 'Configuration for _CFGNAME_ language';

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

ALTER TEXT SEARCH CONFIGURATION _CFGNAME_ ADD MAPPING
    FOR lhword, lpart_hword, lword
	WITH _LATDICTNAME_;

ALTER TEXT SEARCH CONFIGURATION _CFGNAME_ ADD MAPPING
    FOR hword, nlhword, nlpart_hword, nlword, word, part_hword
	WITH _NONLATDICTNAME_;