1 -- complain if script is sourced in psql, rather than via CREATE EXTENSION
2 \echo Use "CREATE EXTENSION pg_bigm" to load this file. \quit
4 CREATE FUNCTION show_bigm(text)
7 LANGUAGE C STRICT IMMUTABLE;
9 CREATE FUNCTION bigm_similarity(text, text)
12 LANGUAGE C STRICT IMMUTABLE;
14 CREATE FUNCTION bigm_similarity_op(text,text)
17 LANGUAGE C STRICT STABLE; -- stable because depends on pg_bigm.similarity_limit
22 PROCEDURE = bigm_similarity_op,
28 -- support functions for gin
29 CREATE FUNCTION gin_extract_value_bigm(text, internal)
32 LANGUAGE C IMMUTABLE STRICT;
34 CREATE FUNCTION gin_extract_query_bigm(text, internal, int2, internal, internal, internal, internal)
37 LANGUAGE C IMMUTABLE STRICT;
39 CREATE FUNCTION gin_bigm_consistent(internal, int2, text, int4, internal, internal, internal, internal)
42 LANGUAGE C IMMUTABLE STRICT;
44 CREATE FUNCTION gin_bigm_compare_partial(text, text, int2, internal)
47 LANGUAGE C IMMUTABLE STRICT;
49 CREATE FUNCTION bigmtextcmp(text, text)
52 LANGUAGE C STRICT IMMUTABLE;
54 -- create the operator class for gin
55 CREATE OPERATOR CLASS gin_bigm_ops
56 FOR TYPE text USING gin
58 OPERATOR 1 pg_catalog.~~ (text, text),
59 OPERATOR 2 =% (text, text),
60 FUNCTION 1 bigmtextcmp (text, text),
61 FUNCTION 2 gin_extract_value_bigm (text, internal),
62 FUNCTION 3 gin_extract_query_bigm (text, internal, int2, internal, internal, internal, internal),
63 FUNCTION 4 gin_bigm_consistent (internal, int2, text, int4, internal, internal, internal, internal),
64 FUNCTION 5 gin_bigm_compare_partial (text, text, int2, internal),
67 CREATE FUNCTION likequery(text)
70 LANGUAGE C STRICT IMMUTABLE;
72 CREATE FUNCTION pg_gin_pending_stats(index regclass, OUT pages int4, OUT tuples int8)
75 LANGUAGE C STRICT IMMUTABLE;
77 CREATE FUNCTION pg_gin_pending_cleanup(index regclass, delay boolean DEFAULT false)
80 LANGUAGE C STRICT IMMUTABLE;
82 /* triConsistent function is available only in 9.4 or later */
87 SELECT current_setting('server_version_num') INTO pgversion;
88 IF pgversion >= '90400' THEN
89 CREATE FUNCTION gin_bigm_triconsistent(internal, int2, text, int4, internal, internal, internal)
92 LANGUAGE C IMMUTABLE STRICT;
93 ALTER OPERATOR FAMILY gin_bigm_ops USING gin ADD
94 FUNCTION 6 (text, text) gin_bigm_triconsistent (internal, int2, text, int4, internal, internal, internal);