-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathjusquci--1.0.sql
49 lines (39 loc) · 1.22 KB
/
jusquci--1.0.sql
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
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
\echo Use "CREATE EXTENSION pair" to load this file. \quit
CREATE OR REPLACE FUNCTION jusquci_parser_start (internal, int)
RETURNS internal
AS 'MODULE_PATHNAME'
LANGUAGE c
STRICT IMMUTABLE;
CREATE OR REPLACE FUNCTION jusquci_parser_gettoken (internal, internal, internal)
RETURNS internal
AS 'MODULE_PATHNAME'
LANGUAGE c
STRICT IMMUTABLE;
CREATE OR REPLACE FUNCTION jusquci_parser_end (internal)
RETURNS void
AS 'MODULE_PATHNAME'
LANGUAGE c
STRICT IMMUTABLE;
CREATE OR REPLACE FUNCTION jusquci_parser_lextype (internal)
RETURNS internal
AS 'MODULE_PATHNAME'
LANGUAGE c
STRICT IMMUTABLE;
DROP TEXT SEARCH PARSER IF EXISTS jusquci CASCADE;
CREATE TEXT SEARCH PARSER jusquci (
START = jusquci_parser_start,
GETTOKEN = jusquci_parser_gettoken,
END = jusquci_parser_end,
LEXTYPES = jusquci_parser_lextype
);
DROP TEXT SEARCH DICTIONARY IF EXISTS jusquci CASCADE;
CREATE TEXT SEARCH DICTIONARY jusquci_stop (
TEMPLATE = simple,
stopwords = french_jusquci
);
CREATE text search configuration jusquci (
parser = 'jusquci'
);
ALTER TEXT SEARCH CONFIGURATION jusquci
ALTER MAPPING FOR word WITH jusquci_stop;