addressing_dictionary--1.1.sql

-- complain if script is sourced in psql, rather than via CREATE EXTENSION
\echo Use "CREATE EXTENSION addressing_dictionary" to load this file. \quit

------------------------------------------------------------
-- Read about how dictionaries should be ordered and what should go in
-- them https://www.postgresql.org/docs/current/textsearch-dictionaries.html
-- before mucking around with ordering or adding new languages.
--


------------------------------------------------------------
-- English configuration
--
CREATE TEXT SEARCH CONFIGURATION addressing_en (
	COPY = simple
);

CREATE TEXT SEARCH DICTIONARY addressing_stop_en (
	TEMPLATE = pg_catalog.simple,
	STOPWORDS = addressing_en
);

CREATE TEXT SEARCH DICTIONARY addressing_syn_en (
	TEMPLATE = pg_catalog.synonym, 
	SYNONYMS = addressing_en
);

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

ALTER TEXT SEARCH CONFIGURATION addressing_en
	ALTER MAPPING FOR asciiword, word
	WITH addresses_ths_en, addressing_syn_en, addressing_stop_en;

------------------------------------------------------------
-- French configuration
--
CREATE TEXT SEARCH CONFIGURATION addressing_fr (
	COPY = simple
);

CREATE TEXT SEARCH DICTIONARY addressing_stop_fr (
	TEMPLATE = pg_catalog.simple,
	STOPWORDS = addressing_fr
);

CREATE TEXT SEARCH DICTIONARY addressing_syn_fr (
	TEMPLATE = pg_catalog.synonym, 
	SYNONYMS = addressing_fr
);


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

ALTER TEXT SEARCH CONFIGURATION addressing_fr
    ALTER MAPPING FOR asciiword, word
    WITH addresses_ths_fr, addressing_syn_fr, addressing_stop_fr;