1/* contrib/btree_gist/btree_gist--1.2--1.3.sql */ 2 3-- complain if script is sourced in psql, rather than via ALTER EXTENSION 4\echo Use "ALTER EXTENSION btree_gist UPDATE TO '1.3'" to load this file. \quit 5 6-- Add support for indexing UUID columns 7 8-- define the GiST support methods 9CREATE FUNCTION gbt_uuid_consistent(internal,uuid,int2,oid,internal) 10RETURNS bool 11AS 'MODULE_PATHNAME' 12LANGUAGE C IMMUTABLE STRICT; 13 14CREATE FUNCTION gbt_uuid_fetch(internal) 15RETURNS internal 16AS 'MODULE_PATHNAME' 17LANGUAGE C IMMUTABLE STRICT; 18 19CREATE FUNCTION gbt_uuid_compress(internal) 20RETURNS internal 21AS 'MODULE_PATHNAME' 22LANGUAGE C IMMUTABLE STRICT; 23 24CREATE FUNCTION gbt_uuid_penalty(internal,internal,internal) 25RETURNS internal 26AS 'MODULE_PATHNAME' 27LANGUAGE C IMMUTABLE STRICT; 28 29CREATE FUNCTION gbt_uuid_picksplit(internal, internal) 30RETURNS internal 31AS 'MODULE_PATHNAME' 32LANGUAGE C IMMUTABLE STRICT; 33 34CREATE FUNCTION gbt_uuid_union(internal, internal) 35RETURNS gbtreekey32 36AS 'MODULE_PATHNAME' 37LANGUAGE C IMMUTABLE STRICT; 38 39CREATE FUNCTION gbt_uuid_same(gbtreekey32, gbtreekey32, internal) 40RETURNS internal 41AS 'MODULE_PATHNAME' 42LANGUAGE C IMMUTABLE STRICT; 43 44-- Create the operator class 45CREATE OPERATOR CLASS gist_uuid_ops 46DEFAULT FOR TYPE uuid USING gist 47AS 48 OPERATOR 1 < , 49 OPERATOR 2 <= , 50 OPERATOR 3 = , 51 OPERATOR 4 >= , 52 OPERATOR 5 > , 53 FUNCTION 1 gbt_uuid_consistent (internal, uuid, int2, oid, internal), 54 FUNCTION 2 gbt_uuid_union (internal, internal), 55 FUNCTION 3 gbt_uuid_compress (internal), 56 FUNCTION 4 gbt_decompress (internal), 57 FUNCTION 5 gbt_uuid_penalty (internal, internal, internal), 58 FUNCTION 6 gbt_uuid_picksplit (internal, internal), 59 FUNCTION 7 gbt_uuid_same (gbtreekey32, gbtreekey32, internal), 60 STORAGE gbtreekey32; 61 62-- These are "loose" in the opfamily for consistency with the rest of btree_gist 63ALTER OPERATOR FAMILY gist_uuid_ops USING gist ADD 64 OPERATOR 6 <> (uuid, uuid) , 65 FUNCTION 9 (uuid, uuid) gbt_uuid_fetch (internal) ; 66