diff options
Diffstat (limited to 'contrib/btree_gist/btree_gist.sql.in')
| -rw-r--r-- | contrib/btree_gist/btree_gist.sql.in | 79 |
1 files changed, 76 insertions, 3 deletions
diff --git a/contrib/btree_gist/btree_gist.sql.in b/contrib/btree_gist/btree_gist.sql.in index 20bd46b5fa..4f0b1291df 100644 --- a/contrib/btree_gist/btree_gist.sql.in +++ b/contrib/btree_gist/btree_gist.sql.in @@ -3,6 +3,23 @@ SET search_path = public; SET autocommit TO 'on'; +-- create type of int2 key +CREATE FUNCTION int2key_in(cstring) +RETURNS int2key +AS 'MODULE_PATHNAME' +LANGUAGE 'c' WITH (isstrict); + +CREATE FUNCTION int2key_out(int2key) +RETURNS cstring +AS 'MODULE_PATHNAME' +LANGUAGE 'c' WITH (isstrict); + +CREATE TYPE int2key ( +INTERNALLENGTH = 4, +INPUT = int2key_in, +OUTPUT = int2key_out +); + -- create type of int4 key CREATE FUNCTION int4key_in(cstring) RETURNS int4key @@ -75,17 +92,17 @@ OUTPUT = float8key_out -- -- -- --- int4 ops +-- int2 ops -- -- -- -- define the GiST support methods -CREATE FUNCTION gint4_consistent(internal,int4,int2) +CREATE FUNCTION gint2_consistent(internal,int2,int2) RETURNS bool AS 'MODULE_PATHNAME' LANGUAGE 'C'; -CREATE FUNCTION gint4_compress(internal) +CREATE FUNCTION gint2_compress(internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE 'C'; @@ -95,6 +112,62 @@ RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE 'C'; +CREATE FUNCTION gint2_penalty(internal,internal,internal) +RETURNS internal +AS 'MODULE_PATHNAME' +LANGUAGE 'C' WITH (isstrict); + +CREATE FUNCTION gint2_picksplit(internal, internal) +RETURNS internal +AS 'MODULE_PATHNAME' +LANGUAGE 'C'; + +CREATE FUNCTION gint2_union(bytea, internal) +RETURNS int4 +AS 'MODULE_PATHNAME' +LANGUAGE 'C'; + +CREATE FUNCTION gint2_same(internal, internal, internal) +RETURNS internal +AS 'MODULE_PATHNAME' +LANGUAGE 'C'; + +-- Create the operator class +CREATE OPERATOR CLASS gist_int2_ops +DEFAULT FOR TYPE int2 USING gist +AS + OPERATOR 1 < , + OPERATOR 2 <= , + OPERATOR 3 = , + OPERATOR 4 >= , + OPERATOR 5 > , + FUNCTION 1 gint2_consistent (internal, int2, int2), + FUNCTION 2 gint2_union (bytea, internal), + FUNCTION 3 gint2_compress (internal), + FUNCTION 4 btree_decompress (internal), + FUNCTION 5 gint2_penalty (internal, internal, internal), + FUNCTION 6 gint2_picksplit (internal, internal), + FUNCTION 7 gint2_same (internal, internal, internal), + STORAGE int2key; + +-- +-- +-- +-- int4 ops +-- +-- +-- +-- define the GiST support methods +CREATE FUNCTION gint4_consistent(internal,int4,int2) +RETURNS bool +AS 'MODULE_PATHNAME' +LANGUAGE 'C'; + +CREATE FUNCTION gint4_compress(internal) +RETURNS internal +AS 'MODULE_PATHNAME' +LANGUAGE 'C'; + CREATE FUNCTION gint4_penalty(internal,internal,internal) RETURNS internal AS 'MODULE_PATHNAME' |