postgres/french/create.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

DROP TEXT SEARCH CONFIGURATION IF EXISTS french_archeo;
DROP TEXT SEARCH DICTIONARY IF EXISTS thesaurus_french_archeo;


CREATE TEXT SEARCH CONFIGURATION french_archeo (
   COPY = french
);

ALTER TEXT SEARCH CONFIGURATION french_archeo
   DROP MAPPING FOR hword_asciipart;
ALTER TEXT SEARCH CONFIGURATION french_archeo
   DROP MAPPING FOR hword_part;


CREATE TEXT SEARCH DICTIONARY thesaurus_french_archeo (
    TEMPLATE = thesaurus,
    DictFile = thesaurus_french_archeo,
    Dictionary = pg_catalog.simple
);

ALTER TEXT SEARCH CONFIGURATION french_archeo
   ALTER MAPPING FOR asciihword, asciiword, hword, word
   WITH thesaurus_french_archeo, french_stem;