1
-- Adjust this setting to control where the objects get created.
2
SET search_path = public;
4
CREATE FUNCTION gbtreekey4_in(cstring)
6
AS 'MODULE_PATHNAME', 'gbtreekey_in'
7
LANGUAGE 'c' WITH (isstrict);
9
CREATE FUNCTION gbtreekey4_out(gbtreekey4)
11
AS 'MODULE_PATHNAME', 'gbtreekey_out'
12
LANGUAGE 'c' WITH (isstrict);
14
CREATE TYPE gbtreekey4 (
16
INPUT = gbtreekey4_in,
17
OUTPUT = gbtreekey4_out
20
CREATE FUNCTION gbtreekey8_in(cstring)
22
AS 'MODULE_PATHNAME', 'gbtreekey_in'
23
LANGUAGE 'c' WITH (isstrict);
25
CREATE FUNCTION gbtreekey8_out(gbtreekey8)
27
AS 'MODULE_PATHNAME', 'gbtreekey_out'
28
LANGUAGE 'c' WITH (isstrict);
30
CREATE TYPE gbtreekey8 (
32
INPUT = gbtreekey8_in,
33
OUTPUT = gbtreekey8_out
36
CREATE FUNCTION gbtreekey16_in(cstring)
38
AS 'MODULE_PATHNAME', 'gbtreekey_in'
39
LANGUAGE 'c' WITH (isstrict);
41
CREATE FUNCTION gbtreekey16_out(gbtreekey16)
43
AS 'MODULE_PATHNAME', 'gbtreekey_out'
44
LANGUAGE 'c' WITH (isstrict);
46
CREATE TYPE gbtreekey16 (
48
INPUT = gbtreekey16_in,
49
OUTPUT = gbtreekey16_out
52
CREATE FUNCTION gbtreekey24_in(cstring)
54
AS 'MODULE_PATHNAME', 'gbtreekey_in'
55
LANGUAGE 'c' WITH (isstrict);
57
CREATE FUNCTION gbtreekey24_out(gbtreekey24)
59
AS 'MODULE_PATHNAME', 'gbtreekey_out'
60
LANGUAGE 'c' WITH (isstrict);
62
CREATE TYPE gbtreekey24 (
64
INPUT = gbtreekey24_in,
65
OUTPUT = gbtreekey24_out
68
CREATE FUNCTION gbtreekey_var_in(cstring)
70
AS 'MODULE_PATHNAME', 'gbtreekey_in'
71
LANGUAGE 'c' WITH (isstrict);
73
CREATE FUNCTION gbtreekey_var_out(gbtreekey_var)
75
AS 'MODULE_PATHNAME', 'gbtreekey_out'
76
LANGUAGE 'c' WITH (isstrict);
78
CREATE TYPE gbtreekey_var (
79
INTERNALLENGTH = VARIABLE,
80
INPUT = gbtreekey_var_in,
81
OUTPUT = gbtreekey_var_out,
94
-- define the GiST support methods
95
CREATE FUNCTION gbt_oid_consistent(internal,oid,int2)
100
CREATE FUNCTION gbt_oid_compress(internal)
105
CREATE FUNCTION gbt_decompress(internal)
110
CREATE FUNCTION gbt_oid_penalty(internal,internal,internal)
113
LANGUAGE 'C' WITH (isstrict);
115
CREATE FUNCTION gbt_oid_picksplit(internal, internal)
120
CREATE FUNCTION gbt_oid_union(bytea, internal)
125
CREATE FUNCTION gbt_oid_same(internal, internal, internal)
130
-- Create the operator class
131
CREATE OPERATOR CLASS gist_oid_ops
132
DEFAULT FOR TYPE oid USING gist
139
FUNCTION 1 gbt_oid_consistent (internal, oid, int2),
140
FUNCTION 2 gbt_oid_union (bytea, internal),
141
FUNCTION 3 gbt_oid_compress (internal),
142
FUNCTION 4 gbt_decompress (internal),
143
FUNCTION 5 gbt_oid_penalty (internal, internal, internal),
144
FUNCTION 6 gbt_oid_picksplit (internal, internal),
145
FUNCTION 7 gbt_oid_same (internal, internal, internal),
156
-- define the GiST support methods
157
CREATE FUNCTION gbt_int2_consistent(internal,int2,int2)
162
CREATE FUNCTION gbt_int2_compress(internal)
167
CREATE FUNCTION gbt_int2_penalty(internal,internal,internal)
170
LANGUAGE 'C' WITH (isstrict);
172
CREATE FUNCTION gbt_int2_picksplit(internal, internal)
177
CREATE FUNCTION gbt_int2_union(bytea, internal)
182
CREATE FUNCTION gbt_int2_same(internal, internal, internal)
187
-- Create the operator class
188
CREATE OPERATOR CLASS gist_int2_ops
189
DEFAULT FOR TYPE int2 USING gist
196
FUNCTION 1 gbt_int2_consistent (internal, int2, int2),
197
FUNCTION 2 gbt_int2_union (bytea, internal),
198
FUNCTION 3 gbt_int2_compress (internal),
199
FUNCTION 4 gbt_decompress (internal),
200
FUNCTION 5 gbt_int2_penalty (internal, internal, internal),
201
FUNCTION 6 gbt_int2_picksplit (internal, internal),
202
FUNCTION 7 gbt_int2_same (internal, internal, internal),
212
-- define the GiST support methods
213
CREATE FUNCTION gbt_int4_consistent(internal,int4,int2)
218
CREATE FUNCTION gbt_int4_compress(internal)
223
CREATE FUNCTION gbt_int4_penalty(internal,internal,internal)
226
LANGUAGE 'C' WITH (isstrict);
228
CREATE FUNCTION gbt_int4_picksplit(internal, internal)
233
CREATE FUNCTION gbt_int4_union(bytea, internal)
238
CREATE FUNCTION gbt_int4_same(internal, internal, internal)
243
-- Create the operator class
244
CREATE OPERATOR CLASS gist_int4_ops
245
DEFAULT FOR TYPE int4 USING gist
252
FUNCTION 1 gbt_int4_consistent (internal, int4, int2),
253
FUNCTION 2 gbt_int4_union (bytea, internal),
254
FUNCTION 3 gbt_int4_compress (internal),
255
FUNCTION 4 gbt_decompress (internal),
256
FUNCTION 5 gbt_int4_penalty (internal, internal, internal),
257
FUNCTION 6 gbt_int4_picksplit (internal, internal),
258
FUNCTION 7 gbt_int4_same (internal, internal, internal),
268
-- define the GiST support methods
269
CREATE FUNCTION gbt_int8_consistent(internal,int8,int2)
274
CREATE FUNCTION gbt_int8_compress(internal)
279
CREATE FUNCTION gbt_int8_penalty(internal,internal,internal)
282
LANGUAGE 'C' WITH (isstrict);
284
CREATE FUNCTION gbt_int8_picksplit(internal, internal)
289
CREATE FUNCTION gbt_int8_union(bytea, internal)
294
CREATE FUNCTION gbt_int8_same(internal, internal, internal)
299
-- Create the operator class
300
CREATE OPERATOR CLASS gist_int8_ops
301
DEFAULT FOR TYPE int8 USING gist
308
FUNCTION 1 gbt_int8_consistent (internal, int8, int2),
309
FUNCTION 2 gbt_int8_union (bytea, internal),
310
FUNCTION 3 gbt_int8_compress (internal),
311
FUNCTION 4 gbt_decompress (internal),
312
FUNCTION 5 gbt_int8_penalty (internal, internal, internal),
313
FUNCTION 6 gbt_int8_picksplit (internal, internal),
314
FUNCTION 7 gbt_int8_same (internal, internal, internal),
325
-- define the GiST support methods
326
CREATE FUNCTION gbt_float4_consistent(internal,float4,int2)
331
CREATE FUNCTION gbt_float4_compress(internal)
336
CREATE FUNCTION gbt_float4_penalty(internal,internal,internal)
339
LANGUAGE 'C' WITH (isstrict);
341
CREATE FUNCTION gbt_float4_picksplit(internal, internal)
346
CREATE FUNCTION gbt_float4_union(bytea, internal)
351
CREATE FUNCTION gbt_float4_same(internal, internal, internal)
356
-- Create the operator class
357
CREATE OPERATOR CLASS gist_float4_ops
358
DEFAULT FOR TYPE float4 USING gist
365
FUNCTION 1 gbt_float4_consistent (internal, float4, int2),
366
FUNCTION 2 gbt_float4_union (bytea, internal),
367
FUNCTION 3 gbt_float4_compress (internal),
368
FUNCTION 4 gbt_decompress (internal),
369
FUNCTION 5 gbt_float4_penalty (internal, internal, internal),
370
FUNCTION 6 gbt_float4_picksplit (internal, internal),
371
FUNCTION 7 gbt_float4_same (internal, internal, internal),
384
-- define the GiST support methods
385
CREATE FUNCTION gbt_float8_consistent(internal,float8,int2)
390
CREATE FUNCTION gbt_float8_compress(internal)
395
CREATE FUNCTION gbt_float8_penalty(internal,internal,internal)
398
LANGUAGE 'C' WITH (isstrict);
400
CREATE FUNCTION gbt_float8_picksplit(internal, internal)
405
CREATE FUNCTION gbt_float8_union(bytea, internal)
410
CREATE FUNCTION gbt_float8_same(internal, internal, internal)
415
-- Create the operator class
416
CREATE OPERATOR CLASS gist_float8_ops
417
DEFAULT FOR TYPE float8 USING gist
424
FUNCTION 1 gbt_float8_consistent (internal, float8, int2),
425
FUNCTION 2 gbt_float8_union (bytea, internal),
426
FUNCTION 3 gbt_float8_compress (internal),
427
FUNCTION 4 gbt_decompress (internal),
428
FUNCTION 5 gbt_float8_penalty (internal, internal, internal),
429
FUNCTION 6 gbt_float8_picksplit (internal, internal),
430
FUNCTION 7 gbt_float8_same (internal, internal, internal),
442
CREATE FUNCTION gbt_ts_consistent(internal,timestamp,int2)
447
CREATE FUNCTION gbt_tstz_consistent(internal,timestamptz,int2)
452
CREATE FUNCTION gbt_ts_compress(internal)
457
CREATE FUNCTION gbt_tstz_compress(internal)
462
CREATE FUNCTION gbt_ts_penalty(internal,internal,internal)
465
LANGUAGE 'C' WITH (isstrict);
467
CREATE FUNCTION gbt_ts_picksplit(internal, internal)
472
CREATE FUNCTION gbt_ts_union(bytea, internal)
477
CREATE FUNCTION gbt_ts_same(internal, internal, internal)
482
-- Create the operator class
483
CREATE OPERATOR CLASS gist_timestamp_ops
484
DEFAULT FOR TYPE timestamp USING gist
491
FUNCTION 1 gbt_ts_consistent (internal, timestamp, int2),
492
FUNCTION 2 gbt_ts_union (bytea, internal),
493
FUNCTION 3 gbt_ts_compress (internal),
494
FUNCTION 4 gbt_decompress (internal),
495
FUNCTION 5 gbt_ts_penalty (internal, internal, internal),
496
FUNCTION 6 gbt_ts_picksplit (internal, internal),
497
FUNCTION 7 gbt_ts_same (internal, internal, internal),
501
-- Create the operator class
502
CREATE OPERATOR CLASS gist_timestamptz_ops
503
DEFAULT FOR TYPE timestamptz USING gist
510
FUNCTION 1 gbt_tstz_consistent (internal, timestamptz, int2),
511
FUNCTION 2 gbt_ts_union (bytea, internal),
512
FUNCTION 3 gbt_tstz_compress (internal),
513
FUNCTION 4 gbt_decompress (internal),
514
FUNCTION 5 gbt_ts_penalty (internal, internal, internal),
515
FUNCTION 6 gbt_ts_picksplit (internal, internal),
516
FUNCTION 7 gbt_ts_same (internal, internal, internal),
528
CREATE FUNCTION gbt_time_consistent(internal,time,int2)
533
CREATE FUNCTION gbt_timetz_consistent(internal,timetz,int2)
538
CREATE FUNCTION gbt_time_compress(internal)
543
CREATE FUNCTION gbt_timetz_compress(internal)
548
CREATE FUNCTION gbt_time_penalty(internal,internal,internal)
551
LANGUAGE 'C' WITH (isstrict);
553
CREATE FUNCTION gbt_time_picksplit(internal, internal)
558
CREATE FUNCTION gbt_time_union(bytea, internal)
563
CREATE FUNCTION gbt_time_same(internal, internal, internal)
568
-- Create the operator class
569
CREATE OPERATOR CLASS gist_time_ops
570
DEFAULT FOR TYPE time USING gist
577
FUNCTION 1 gbt_time_consistent (internal, time, int2),
578
FUNCTION 2 gbt_time_union (bytea, internal),
579
FUNCTION 3 gbt_time_compress (internal),
580
FUNCTION 4 gbt_decompress (internal),
581
FUNCTION 5 gbt_time_penalty (internal, internal, internal),
582
FUNCTION 6 gbt_time_picksplit (internal, internal),
583
FUNCTION 7 gbt_time_same (internal, internal, internal),
586
CREATE OPERATOR CLASS gist_timetz_ops
587
DEFAULT FOR TYPE timetz USING gist
589
OPERATOR 1 < RECHECK ,
590
OPERATOR 2 <= RECHECK ,
591
OPERATOR 3 = RECHECK ,
592
OPERATOR 4 >= RECHECK ,
593
OPERATOR 5 > RECHECK ,
594
FUNCTION 1 gbt_timetz_consistent (internal, timetz, int2),
595
FUNCTION 2 gbt_time_union (bytea, internal),
596
FUNCTION 3 gbt_timetz_compress (internal),
597
FUNCTION 4 gbt_decompress (internal),
598
FUNCTION 5 gbt_time_penalty (internal, internal, internal),
599
FUNCTION 6 gbt_time_picksplit (internal, internal),
600
FUNCTION 7 gbt_time_same (internal, internal, internal),
612
CREATE FUNCTION gbt_date_consistent(internal,date,int2)
617
CREATE FUNCTION gbt_date_compress(internal)
622
CREATE FUNCTION gbt_date_penalty(internal,internal,internal)
625
LANGUAGE 'C' WITH (isstrict);
627
CREATE FUNCTION gbt_date_picksplit(internal, internal)
632
CREATE FUNCTION gbt_date_union(bytea, internal)
637
CREATE FUNCTION gbt_date_same(internal, internal, internal)
642
-- Create the operator class
643
CREATE OPERATOR CLASS gist_date_ops
644
DEFAULT FOR TYPE date USING gist
651
FUNCTION 1 gbt_date_consistent (internal, date, int2),
652
FUNCTION 2 gbt_date_union (bytea, internal),
653
FUNCTION 3 gbt_date_compress (internal),
654
FUNCTION 4 gbt_decompress (internal),
655
FUNCTION 5 gbt_date_penalty (internal, internal, internal),
656
FUNCTION 6 gbt_date_picksplit (internal, internal),
657
FUNCTION 7 gbt_date_same (internal, internal, internal),
669
CREATE FUNCTION gbt_intv_consistent(internal,interval,int2)
674
CREATE FUNCTION gbt_intv_compress(internal)
679
CREATE FUNCTION gbt_intv_decompress(internal)
684
CREATE FUNCTION gbt_intv_penalty(internal,internal,internal)
687
LANGUAGE 'C' WITH (isstrict);
689
CREATE FUNCTION gbt_intv_picksplit(internal, internal)
694
CREATE FUNCTION gbt_intv_union(bytea, internal)
699
CREATE FUNCTION gbt_intv_same(internal, internal, internal)
704
-- Create the operator class
705
CREATE OPERATOR CLASS gist_interval_ops
706
DEFAULT FOR TYPE interval USING gist
713
FUNCTION 1 gbt_intv_consistent (internal, interval, int2),
714
FUNCTION 2 gbt_intv_union (bytea, internal),
715
FUNCTION 3 gbt_intv_compress (internal),
716
FUNCTION 4 gbt_intv_decompress (internal),
717
FUNCTION 5 gbt_intv_penalty (internal, internal, internal),
718
FUNCTION 6 gbt_intv_picksplit (internal, internal),
719
FUNCTION 7 gbt_intv_same (internal, internal, internal),
729
-- define the GiST support methods
730
CREATE FUNCTION gbt_cash_consistent(internal,money,int2)
735
CREATE FUNCTION gbt_cash_compress(internal)
740
CREATE FUNCTION gbt_cash_penalty(internal,internal,internal)
743
LANGUAGE 'C' WITH (isstrict);
745
CREATE FUNCTION gbt_cash_picksplit(internal, internal)
750
CREATE FUNCTION gbt_cash_union(bytea, internal)
755
CREATE FUNCTION gbt_cash_same(internal, internal, internal)
760
-- Create the operator class
761
CREATE OPERATOR CLASS gist_cash_ops
762
DEFAULT FOR TYPE money USING gist
769
FUNCTION 1 gbt_cash_consistent (internal, money, int2),
770
FUNCTION 2 gbt_cash_union (bytea, internal),
771
FUNCTION 3 gbt_cash_compress (internal),
772
FUNCTION 4 gbt_decompress (internal),
773
FUNCTION 5 gbt_cash_penalty (internal, internal, internal),
774
FUNCTION 6 gbt_cash_picksplit (internal, internal),
775
FUNCTION 7 gbt_cash_same (internal, internal, internal),
785
-- define the GiST support methods
786
CREATE FUNCTION gbt_macad_consistent(internal,macaddr,int2)
791
CREATE FUNCTION gbt_macad_compress(internal)
796
CREATE FUNCTION gbt_macad_penalty(internal,internal,internal)
799
LANGUAGE 'C' WITH (isstrict);
801
CREATE FUNCTION gbt_macad_picksplit(internal, internal)
806
CREATE FUNCTION gbt_macad_union(bytea, internal)
811
CREATE FUNCTION gbt_macad_same(internal, internal, internal)
816
-- Create the operator class
817
CREATE OPERATOR CLASS gist_macaddr_ops
818
DEFAULT FOR TYPE macaddr USING gist
825
FUNCTION 1 gbt_macad_consistent (internal, macaddr, int2),
826
FUNCTION 2 gbt_macad_union (bytea, internal),
827
FUNCTION 3 gbt_macad_compress (internal),
828
FUNCTION 4 gbt_decompress (internal),
829
FUNCTION 5 gbt_macad_penalty (internal, internal, internal),
830
FUNCTION 6 gbt_macad_picksplit (internal, internal),
831
FUNCTION 7 gbt_macad_same (internal, internal, internal),
843
-- define the GiST support methods
844
CREATE FUNCTION gbt_text_consistent(internal,text,int2)
849
CREATE FUNCTION gbt_bpchar_consistent(internal,bpchar,int2)
854
CREATE FUNCTION gbt_text_compress(internal)
859
CREATE FUNCTION gbt_bpchar_compress(internal)
864
CREATE FUNCTION gbt_text_penalty(internal,internal,internal)
867
LANGUAGE 'C' WITH (isstrict);
869
CREATE FUNCTION gbt_text_picksplit(internal, internal)
874
CREATE FUNCTION gbt_text_union(bytea, internal)
875
RETURNS gbtreekey_var
879
CREATE FUNCTION gbt_text_same(internal, internal, internal)
884
-- Create the operator class
885
CREATE OPERATOR CLASS gist_text_ops
886
DEFAULT FOR TYPE text USING gist
893
FUNCTION 1 gbt_text_consistent (internal, text, int2),
894
FUNCTION 2 gbt_text_union (bytea, internal),
895
FUNCTION 3 gbt_text_compress (internal),
896
FUNCTION 4 gbt_decompress (internal),
897
FUNCTION 5 gbt_text_penalty (internal, internal, internal),
898
FUNCTION 6 gbt_text_picksplit (internal, internal),
899
FUNCTION 7 gbt_text_same (internal, internal, internal),
900
STORAGE gbtreekey_var;
903
---- Create the operator class
904
CREATE OPERATOR CLASS gist_bpchar_ops
905
DEFAULT FOR TYPE bpchar USING gist
912
FUNCTION 1 gbt_bpchar_consistent (internal, bpchar , int2),
913
FUNCTION 2 gbt_text_union (bytea, internal),
914
FUNCTION 3 gbt_bpchar_compress (internal),
915
FUNCTION 4 gbt_decompress (internal),
916
FUNCTION 5 gbt_text_penalty (internal, internal, internal),
917
FUNCTION 6 gbt_text_picksplit (internal, internal),
918
FUNCTION 7 gbt_text_same (internal, internal, internal),
919
STORAGE gbtreekey_var;
929
-- define the GiST support methods
930
CREATE FUNCTION gbt_bytea_consistent(internal,bytea,int2)
935
CREATE FUNCTION gbt_bytea_compress(internal)
940
CREATE FUNCTION gbt_bytea_penalty(internal,internal,internal)
943
LANGUAGE 'C' WITH (isstrict);
945
CREATE FUNCTION gbt_bytea_picksplit(internal, internal)
950
CREATE FUNCTION gbt_bytea_union(bytea, internal)
951
RETURNS gbtreekey_var
955
CREATE FUNCTION gbt_bytea_same(internal, internal, internal)
960
-- Create the operator class
961
CREATE OPERATOR CLASS gist_bytea_ops
962
DEFAULT FOR TYPE bytea USING gist
969
FUNCTION 1 gbt_bytea_consistent (internal, bytea, int2),
970
FUNCTION 2 gbt_bytea_union (bytea, internal),
971
FUNCTION 3 gbt_bytea_compress (internal),
972
FUNCTION 4 gbt_decompress (internal),
973
FUNCTION 5 gbt_bytea_penalty (internal, internal, internal),
974
FUNCTION 6 gbt_bytea_picksplit (internal, internal),
975
FUNCTION 7 gbt_bytea_same (internal, internal, internal),
976
STORAGE gbtreekey_var;
986
-- define the GiST support methods
987
CREATE FUNCTION gbt_numeric_consistent(internal,numeric,int2)
992
CREATE FUNCTION gbt_numeric_compress(internal)
997
CREATE FUNCTION gbt_numeric_penalty(internal,internal,internal)
1000
LANGUAGE 'C' WITH (isstrict);
1002
CREATE FUNCTION gbt_numeric_picksplit(internal, internal)
1004
AS 'MODULE_PATHNAME'
1007
CREATE FUNCTION gbt_numeric_union(bytea, internal)
1008
RETURNS gbtreekey_var
1009
AS 'MODULE_PATHNAME'
1012
CREATE FUNCTION gbt_numeric_same(internal, internal, internal)
1014
AS 'MODULE_PATHNAME'
1017
-- Create the operator class
1018
CREATE OPERATOR CLASS gist_numeric_ops
1019
DEFAULT FOR TYPE numeric USING gist
1026
FUNCTION 1 gbt_numeric_consistent (internal, numeric, int2),
1027
FUNCTION 2 gbt_numeric_union (bytea, internal),
1028
FUNCTION 3 gbt_numeric_compress (internal),
1029
FUNCTION 4 gbt_decompress (internal),
1030
FUNCTION 5 gbt_numeric_penalty (internal, internal, internal),
1031
FUNCTION 6 gbt_numeric_picksplit (internal, internal),
1032
FUNCTION 7 gbt_numeric_same (internal, internal, internal),
1033
STORAGE gbtreekey_var;
1041
-- define the GiST support methods
1042
CREATE FUNCTION gbt_bit_consistent(internal,bit,int2)
1044
AS 'MODULE_PATHNAME'
1047
CREATE FUNCTION gbt_bit_compress(internal)
1049
AS 'MODULE_PATHNAME'
1052
CREATE FUNCTION gbt_bit_penalty(internal,internal,internal)
1054
AS 'MODULE_PATHNAME'
1055
LANGUAGE 'C' WITH (isstrict);
1057
CREATE FUNCTION gbt_bit_picksplit(internal, internal)
1059
AS 'MODULE_PATHNAME'
1062
CREATE FUNCTION gbt_bit_union(bytea, internal)
1063
RETURNS gbtreekey_var
1064
AS 'MODULE_PATHNAME'
1067
CREATE FUNCTION gbt_bit_same(internal, internal, internal)
1069
AS 'MODULE_PATHNAME'
1072
-- Create the operator class
1073
CREATE OPERATOR CLASS gist_bit_ops
1074
DEFAULT FOR TYPE bit USING gist
1081
FUNCTION 1 gbt_bit_consistent (internal, bit, int2),
1082
FUNCTION 2 gbt_bit_union (bytea, internal),
1083
FUNCTION 3 gbt_bit_compress (internal),
1084
FUNCTION 4 gbt_decompress (internal),
1085
FUNCTION 5 gbt_bit_penalty (internal, internal, internal),
1086
FUNCTION 6 gbt_bit_picksplit (internal, internal),
1087
FUNCTION 7 gbt_bit_same (internal, internal, internal),
1088
STORAGE gbtreekey_var;
1091
-- Create the operator class
1092
CREATE OPERATOR CLASS gist_vbit_ops
1093
DEFAULT FOR TYPE varbit USING gist
1100
FUNCTION 1 gbt_bit_consistent (internal, bit, int2),
1101
FUNCTION 2 gbt_bit_union (bytea, internal),
1102
FUNCTION 3 gbt_bit_compress (internal),
1103
FUNCTION 4 gbt_decompress (internal),
1104
FUNCTION 5 gbt_bit_penalty (internal, internal, internal),
1105
FUNCTION 6 gbt_bit_picksplit (internal, internal),
1106
FUNCTION 7 gbt_bit_same (internal, internal, internal),
1107
STORAGE gbtreekey_var;
1118
-- define the GiST support methods
1119
CREATE FUNCTION gbt_inet_consistent(internal,inet,int2)
1121
AS 'MODULE_PATHNAME'
1124
CREATE FUNCTION gbt_cidr_consistent(internal,cidr,int2)
1126
AS 'MODULE_PATHNAME'
1129
CREATE FUNCTION gbt_inet_compress(internal)
1131
AS 'MODULE_PATHNAME'
1134
CREATE FUNCTION gbt_cidr_compress(internal)
1136
AS 'MODULE_PATHNAME'
1139
CREATE FUNCTION gbt_inet_penalty(internal,internal,internal)
1141
AS 'MODULE_PATHNAME'
1142
LANGUAGE 'C' WITH (isstrict);
1144
CREATE FUNCTION gbt_inet_picksplit(internal, internal)
1146
AS 'MODULE_PATHNAME'
1149
CREATE FUNCTION gbt_inet_union(bytea, internal)
1151
AS 'MODULE_PATHNAME'
1154
CREATE FUNCTION gbt_inet_same(internal, internal, internal)
1156
AS 'MODULE_PATHNAME'
1159
-- Create the operator class
1160
CREATE OPERATOR CLASS gist_inet_ops
1161
DEFAULT FOR TYPE inet USING gist
1163
OPERATOR 1 < RECHECK ,
1164
OPERATOR 2 <= RECHECK ,
1165
OPERATOR 3 = RECHECK ,
1166
OPERATOR 4 >= RECHECK ,
1167
OPERATOR 5 > RECHECK ,
1168
FUNCTION 1 gbt_inet_consistent (internal, inet, int2),
1169
FUNCTION 2 gbt_inet_union (bytea, internal),
1170
FUNCTION 3 gbt_inet_compress (internal),
1171
FUNCTION 4 gbt_decompress (internal),
1172
FUNCTION 5 gbt_inet_penalty (internal, internal, internal),
1173
FUNCTION 6 gbt_inet_picksplit (internal, internal),
1174
FUNCTION 7 gbt_inet_same (internal, internal, internal),
1175
STORAGE gbtreekey16;
1177
-- Create the operator class
1178
CREATE OPERATOR CLASS gist_cidr_ops
1179
DEFAULT FOR TYPE cidr USING gist
1181
OPERATOR 1 < RECHECK ,
1182
OPERATOR 2 <= RECHECK ,
1183
OPERATOR 3 = RECHECK ,
1184
OPERATOR 4 >= RECHECK ,
1185
OPERATOR 5 > RECHECK ,
1186
FUNCTION 1 gbt_cidr_consistent (internal, cidr, int2),
1187
FUNCTION 2 gbt_inet_union (bytea, internal),
1188
FUNCTION 3 gbt_inet_compress (internal),
1189
FUNCTION 4 gbt_decompress (internal),
1190
FUNCTION 5 gbt_inet_penalty (internal, internal, internal),
1191
FUNCTION 6 gbt_inet_picksplit (internal, internal),
1192
FUNCTION 7 gbt_inet_same (internal, internal, internal),
1193
STORAGE gbtreekey16;