codekingpro/portable-devtools

1/* src/test/modules/spgist_name_ops/spgist_name_ops--1.0.sql */2 3-- complain if script is sourced in psql, rather than via CREATE EXTENSION4\echo Use "CREATE EXTENSION spgist_name_ops" to load this file. \quit5 6CREATE FUNCTION spgist_name_config(internal, internal)7RETURNS void IMMUTABLE PARALLEL SAFE STRICT8AS 'MODULE_PATHNAME' LANGUAGE C;9 10CREATE FUNCTION spgist_name_choose(internal, internal)11RETURNS void IMMUTABLE PARALLEL SAFE STRICT12AS 'MODULE_PATHNAME' LANGUAGE C;13 14CREATE FUNCTION spgist_name_inner_consistent(internal, internal)15RETURNS void IMMUTABLE PARALLEL SAFE STRICT16AS 'MODULE_PATHNAME' LANGUAGE C;17 18CREATE FUNCTION spgist_name_leaf_consistent(internal, internal)19RETURNS boolean IMMUTABLE PARALLEL SAFE STRICT20AS 'MODULE_PATHNAME' LANGUAGE C;21 22CREATE FUNCTION spgist_name_compress(name)23RETURNS text IMMUTABLE PARALLEL SAFE STRICT24AS 'MODULE_PATHNAME' LANGUAGE C;25 26CREATE OPERATOR CLASS name_ops DEFAULT FOR TYPE name27USING spgist AS28	OPERATOR	1	< ,29	OPERATOR	2	<= ,30	OPERATOR	3	= ,31	OPERATOR	4	>= ,32	OPERATOR	5	> ,33	FUNCTION	1	spgist_name_config(internal, internal),34	FUNCTION	2	spgist_name_choose(internal, internal),35	FUNCTION	3	spg_text_picksplit(internal, internal),36	FUNCTION	4	spgist_name_inner_consistent(internal, internal),37	FUNCTION	5	spgist_name_leaf_consistent(internal, internal),38	FUNCTION	6	spgist_name_compress(name),39	STORAGE text;40 41-- Also test old-style where the STORAGE clause is disallowed42CREATE OPERATOR CLASS name_ops_old FOR TYPE name43USING spgist AS44	OPERATOR	1	< ,45	OPERATOR	2	<= ,46	OPERATOR	3	= ,47	OPERATOR	4	>= ,48	OPERATOR	5	> ,49	FUNCTION	1	spgist_name_config(internal, internal),50	FUNCTION	2	spgist_name_choose(internal, internal),51	FUNCTION	3	spg_text_picksplit(internal, internal),52	FUNCTION	4	spgist_name_inner_consistent(internal, internal),53	FUNCTION	5	spgist_name_leaf_consistent(internal, internal),54	FUNCTION	6	spgist_name_compress(name);55