1/* contrib/btree_gist/btree_gist--1.0--1.1.sql */ 2 3-- complain if script is sourced in psql, rather than via CREATE EXTENSION 4\echo Use "ALTER EXTENSION btree_gist UPDATE TO '1.1'" to load this file. \quit 5 6-- Index-only scan support new in 9.5. 7CREATE FUNCTION gbt_oid_fetch(internal) 8RETURNS internal 9AS 'MODULE_PATHNAME' 10LANGUAGE C IMMUTABLE STRICT; 11 12CREATE FUNCTION gbt_int2_fetch(internal) 13RETURNS internal 14AS 'MODULE_PATHNAME' 15LANGUAGE C IMMUTABLE STRICT; 16 17CREATE FUNCTION gbt_int4_fetch(internal) 18RETURNS internal 19AS 'MODULE_PATHNAME' 20LANGUAGE C IMMUTABLE STRICT; 21 22CREATE FUNCTION gbt_int8_fetch(internal) 23RETURNS internal 24AS 'MODULE_PATHNAME' 25LANGUAGE C IMMUTABLE STRICT; 26 27CREATE FUNCTION gbt_float4_fetch(internal) 28RETURNS internal 29AS 'MODULE_PATHNAME' 30LANGUAGE C IMMUTABLE STRICT; 31 32CREATE FUNCTION gbt_float8_fetch(internal) 33RETURNS internal 34AS 'MODULE_PATHNAME' 35LANGUAGE C IMMUTABLE STRICT; 36 37CREATE FUNCTION gbt_ts_fetch(internal) 38RETURNS internal 39AS 'MODULE_PATHNAME' 40LANGUAGE C IMMUTABLE STRICT; 41 42CREATE FUNCTION gbt_time_fetch(internal) 43RETURNS internal 44AS 'MODULE_PATHNAME' 45LANGUAGE C IMMUTABLE STRICT; 46 47CREATE FUNCTION gbt_date_fetch(internal) 48RETURNS internal 49AS 'MODULE_PATHNAME' 50LANGUAGE C IMMUTABLE STRICT; 51 52CREATE FUNCTION gbt_intv_fetch(internal) 53RETURNS internal 54AS 'MODULE_PATHNAME' 55LANGUAGE C IMMUTABLE STRICT; 56 57CREATE FUNCTION gbt_cash_fetch(internal) 58RETURNS internal 59AS 'MODULE_PATHNAME' 60LANGUAGE C IMMUTABLE STRICT; 61 62CREATE FUNCTION gbt_macad_fetch(internal) 63RETURNS internal 64AS 'MODULE_PATHNAME' 65LANGUAGE C IMMUTABLE STRICT; 66 67CREATE FUNCTION gbt_var_fetch(internal) 68RETURNS internal 69AS 'MODULE_PATHNAME' 70LANGUAGE C IMMUTABLE STRICT; 71 72ALTER OPERATOR FAMILY gist_oid_ops USING gist ADD 73 FUNCTION 9 (oid, oid) gbt_oid_fetch (internal) ; 74 75ALTER OPERATOR FAMILY gist_int2_ops USING gist ADD 76 FUNCTION 9 (int2, int2) gbt_int2_fetch (internal) ; 77 78ALTER OPERATOR FAMILY gist_int4_ops USING gist ADD 79 FUNCTION 9 (int4, int4) gbt_int4_fetch (internal) ; 80 81ALTER OPERATOR FAMILY gist_int8_ops USING gist ADD 82 FUNCTION 9 (int8, int8) gbt_int8_fetch (internal) ; 83 84ALTER OPERATOR FAMILY gist_float4_ops USING gist ADD 85 FUNCTION 9 (float4, float4) gbt_float4_fetch (internal) ; 86 87ALTER OPERATOR FAMILY gist_float8_ops USING gist ADD 88 FUNCTION 9 (float8, float8) gbt_float8_fetch (internal) ; 89 90ALTER OPERATOR FAMILY gist_timestamp_ops USING gist ADD 91 FUNCTION 9 (timestamp, timestamp) gbt_ts_fetch (internal) ; 92 93ALTER OPERATOR FAMILY gist_timestamptz_ops USING gist ADD 94 FUNCTION 9 (timestamptz, timestamptz) gbt_ts_fetch (internal) ; 95 96ALTER OPERATOR FAMILY gist_time_ops USING gist ADD 97 FUNCTION 9 (time, time) gbt_time_fetch (internal) ; 98 99ALTER OPERATOR FAMILY gist_date_ops USING gist ADD 100 FUNCTION 9 (date, date) gbt_date_fetch (internal) ; 101 102ALTER OPERATOR FAMILY gist_interval_ops USING gist ADD 103 FUNCTION 9 (interval, interval) gbt_intv_fetch (internal) ; 104 105ALTER OPERATOR FAMILY gist_cash_ops USING gist ADD 106 FUNCTION 9 (money, money) gbt_cash_fetch (internal) ; 107 108ALTER OPERATOR FAMILY gist_macaddr_ops USING gist ADD 109 FUNCTION 9 (macaddr, macaddr) gbt_macad_fetch (internal) ; 110 111ALTER OPERATOR FAMILY gist_text_ops USING gist ADD 112 FUNCTION 9 (text, text) gbt_var_fetch (internal) ; 113 114ALTER OPERATOR FAMILY gist_bpchar_ops USING gist ADD 115 FUNCTION 9 (bpchar, bpchar) gbt_var_fetch (internal) ; 116 117ALTER OPERATOR FAMILY gist_bytea_ops USING gist ADD 118 FUNCTION 9 (bytea, bytea) gbt_var_fetch (internal) ; 119 120ALTER OPERATOR FAMILY gist_numeric_ops USING gist ADD 121 FUNCTION 9 (numeric, numeric) gbt_var_fetch (internal) ; 122 123ALTER OPERATOR FAMILY gist_bit_ops USING gist ADD 124 FUNCTION 9 (bit, bit) gbt_var_fetch (internal) ; 125 126ALTER OPERATOR FAMILY gist_vbit_ops USING gist ADD 127 FUNCTION 9 (varbit, varbit) gbt_var_fetch (internal) ; 128