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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
|
CREATE OR REPLACE FUNCTION bingo_handler(internal)
RETURNS index_am_handler
AS 'BINGO_PATHNAME'
LANGUAGE C STRICT VOLATILE;
CREATE ACCESS METHOD bingo_idx TYPE INDEX HANDLER bingo_handler;
--**************************** MANGO OPERATOR CLASS *********************
CREATE OPERATOR CLASS molecule
FOR TYPE text USING bingo_idx
AS
OPERATOR 1 public.@ (text, sub),
OPERATOR 2 public.@ (text, exact),
OPERATOR 3 public.@ (text, smarts),
OPERATOR 4 public.@ (text, gross),
OPERATOR 5 public.< (text, mass),
OPERATOR 6 public.> (text, mass),
OPERATOR 7 public.@ (text, sim),
FUNCTION 1 matchSub(text, sub),
FUNCTION 2 matchExact(text, exact),
FUNCTION 3 matchSmarts(text, smarts),
FUNCTION 4 matchGross(text, gross),
FUNCTION 5 _match_mass_less(text, mass),
FUNCTION 6 _match_mass_great(text, mass),
FUNCTION 7 matchSim(text, sim);
CREATE OPERATOR CLASS bmolecule
FOR TYPE bytea USING bingo_idx
AS
OPERATOR 1 public.@ (bytea, sub),
OPERATOR 2 public.@ (bytea, exact),
OPERATOR 3 public.@ (bytea, smarts),
OPERATOR 4 public.@ (bytea, gross),
OPERATOR 5 public.< (bytea, mass),
OPERATOR 6 public.> (bytea, mass),
OPERATOR 7 public.@ (bytea, sim),
FUNCTION 1 matchSub(bytea, sub),
FUNCTION 2 matchExact(bytea, exact),
FUNCTION 3 matchSmarts(bytea, smarts),
FUNCTION 4 matchGross(bytea, gross),
FUNCTION 5 _match_mass_less(bytea, mass),
FUNCTION 6 _match_mass_great(bytea, mass),
FUNCTION 7 matchSim(bytea, sim);
--**************************** RINGO OPERATOR CLASS *********************
CREATE OPERATOR CLASS reaction
FOR TYPE text USING bingo_idx
AS
OPERATOR 1 public.@ (text, rsub),
OPERATOR 2 public.@ (text, rexact),
OPERATOR 3 public.@ (text, rsmarts),
FUNCTION 1 matchRSub(text, rsub),
FUNCTION 2 matchRExact(text, rexact),
FUNCTION 3 matchRSmarts(text, rsmarts);
CREATE OPERATOR CLASS breaction
FOR TYPE bytea USING bingo_idx
AS
OPERATOR 1 public.@ (bytea, rsub),
OPERATOR 2 public.@ (bytea, rexact),
OPERATOR 3 public.@ (bytea, rsmarts),
FUNCTION 1 matchRSub(bytea, rsub),
FUNCTION 2 matchRExact(bytea, rexact),
FUNCTION 3 matchRSmarts(bytea, rsmarts);
|
