1 /* contrib/btree_gin/btree_gin--1.0.sql */
3 CREATE FUNCTION gin_btree_consistent(internal, int2, anyelement, int4, internal, internal)
6 LANGUAGE C STRICT IMMUTABLE;
8 CREATE FUNCTION gin_extract_value_int2(int2, internal)
11 LANGUAGE C STRICT IMMUTABLE;
13 CREATE FUNCTION gin_compare_prefix_int2(int2, int2, int2, internal)
16 LANGUAGE C STRICT IMMUTABLE;
18 CREATE FUNCTION gin_extract_query_int2(int2, internal, int2, internal, internal)
21 LANGUAGE C STRICT IMMUTABLE;
23 CREATE OPERATOR CLASS int2_ops
24 DEFAULT FOR TYPE int2 USING gin
31 FUNCTION 1 btint2cmp(int2,int2),
32 FUNCTION 2 gin_extract_value_int2(int2, internal),
33 FUNCTION 3 gin_extract_query_int2(int2, internal, int2, internal, internal),
34 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
35 FUNCTION 5 gin_compare_prefix_int2(int2,int2,int2, internal),
38 CREATE FUNCTION gin_extract_value_int4(int4, internal)
41 LANGUAGE C STRICT IMMUTABLE;
43 CREATE FUNCTION gin_compare_prefix_int4(int4, int4, int2, internal)
46 LANGUAGE C STRICT IMMUTABLE;
48 CREATE FUNCTION gin_extract_query_int4(int4, internal, int2, internal, internal)
51 LANGUAGE C STRICT IMMUTABLE;
53 CREATE OPERATOR CLASS int4_ops
54 DEFAULT FOR TYPE int4 USING gin
61 FUNCTION 1 btint4cmp(int4,int4),
62 FUNCTION 2 gin_extract_value_int4(int4, internal),
63 FUNCTION 3 gin_extract_query_int4(int4, internal, int2, internal, internal),
64 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
65 FUNCTION 5 gin_compare_prefix_int4(int4,int4,int2, internal),
68 CREATE FUNCTION gin_extract_value_int8(int8, internal)
71 LANGUAGE C STRICT IMMUTABLE;
73 CREATE FUNCTION gin_compare_prefix_int8(int8, int8, int2, internal)
76 LANGUAGE C STRICT IMMUTABLE;
78 CREATE FUNCTION gin_extract_query_int8(int8, internal, int2, internal, internal)
81 LANGUAGE C STRICT IMMUTABLE;
83 CREATE OPERATOR CLASS int8_ops
84 DEFAULT FOR TYPE int8 USING gin
91 FUNCTION 1 btint8cmp(int8,int8),
92 FUNCTION 2 gin_extract_value_int8(int8, internal),
93 FUNCTION 3 gin_extract_query_int8(int8, internal, int2, internal, internal),
94 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
95 FUNCTION 5 gin_compare_prefix_int8(int8,int8,int2, internal),
98 CREATE FUNCTION gin_extract_value_float4(float4, internal)
101 LANGUAGE C STRICT IMMUTABLE;
103 CREATE FUNCTION gin_compare_prefix_float4(float4, float4, int2, internal)
106 LANGUAGE C STRICT IMMUTABLE;
108 CREATE FUNCTION gin_extract_query_float4(float4, internal, int2, internal, internal)
111 LANGUAGE C STRICT IMMUTABLE;
113 CREATE OPERATOR CLASS float4_ops
114 DEFAULT FOR TYPE float4 USING gin
121 FUNCTION 1 btfloat4cmp(float4,float4),
122 FUNCTION 2 gin_extract_value_float4(float4, internal),
123 FUNCTION 3 gin_extract_query_float4(float4, internal, int2, internal, internal),
124 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
125 FUNCTION 5 gin_compare_prefix_float4(float4,float4,int2, internal),
128 CREATE FUNCTION gin_extract_value_float8(float8, internal)
131 LANGUAGE C STRICT IMMUTABLE;
133 CREATE FUNCTION gin_compare_prefix_float8(float8, float8, int2, internal)
136 LANGUAGE C STRICT IMMUTABLE;
138 CREATE FUNCTION gin_extract_query_float8(float8, internal, int2, internal, internal)
141 LANGUAGE C STRICT IMMUTABLE;
143 CREATE OPERATOR CLASS float8_ops
144 DEFAULT FOR TYPE float8 USING gin
151 FUNCTION 1 btfloat8cmp(float8,float8),
152 FUNCTION 2 gin_extract_value_float8(float8, internal),
153 FUNCTION 3 gin_extract_query_float8(float8, internal, int2, internal, internal),
154 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
155 FUNCTION 5 gin_compare_prefix_float8(float8,float8,int2, internal),
158 CREATE FUNCTION gin_extract_value_money(money, internal)
161 LANGUAGE C STRICT IMMUTABLE;
163 CREATE FUNCTION gin_compare_prefix_money(money, money, int2, internal)
166 LANGUAGE C STRICT IMMUTABLE;
168 CREATE FUNCTION gin_extract_query_money(money, internal, int2, internal, internal)
171 LANGUAGE C STRICT IMMUTABLE;
173 CREATE OPERATOR CLASS money_ops
174 DEFAULT FOR TYPE money USING gin
181 FUNCTION 1 cash_cmp(money,money),
182 FUNCTION 2 gin_extract_value_money(money, internal),
183 FUNCTION 3 gin_extract_query_money(money, internal, int2, internal, internal),
184 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
185 FUNCTION 5 gin_compare_prefix_money(money,money,int2, internal),
188 CREATE FUNCTION gin_extract_value_oid(oid, internal)
191 LANGUAGE C STRICT IMMUTABLE;
193 CREATE FUNCTION gin_compare_prefix_oid(oid, oid, int2, internal)
196 LANGUAGE C STRICT IMMUTABLE;
198 CREATE FUNCTION gin_extract_query_oid(oid, internal, int2, internal, internal)
201 LANGUAGE C STRICT IMMUTABLE;
203 CREATE OPERATOR CLASS oid_ops
204 DEFAULT FOR TYPE oid USING gin
211 FUNCTION 1 btoidcmp(oid,oid),
212 FUNCTION 2 gin_extract_value_oid(oid, internal),
213 FUNCTION 3 gin_extract_query_oid(oid, internal, int2, internal, internal),
214 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
215 FUNCTION 5 gin_compare_prefix_oid(oid,oid,int2, internal),
218 CREATE FUNCTION gin_extract_value_timestamp(timestamp, internal)
221 LANGUAGE C STRICT IMMUTABLE;
223 CREATE FUNCTION gin_compare_prefix_timestamp(timestamp, timestamp, int2, internal)
226 LANGUAGE C STRICT IMMUTABLE;
228 CREATE FUNCTION gin_extract_query_timestamp(timestamp, internal, int2, internal, internal)
231 LANGUAGE C STRICT IMMUTABLE;
233 CREATE OPERATOR CLASS timestamp_ops
234 DEFAULT FOR TYPE timestamp USING gin
241 FUNCTION 1 timestamp_cmp(timestamp,timestamp),
242 FUNCTION 2 gin_extract_value_timestamp(timestamp, internal),
243 FUNCTION 3 gin_extract_query_timestamp(timestamp, internal, int2, internal, internal),
244 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
245 FUNCTION 5 gin_compare_prefix_timestamp(timestamp,timestamp,int2, internal),
248 CREATE FUNCTION gin_extract_value_timestamptz(timestamptz, internal)
251 LANGUAGE C STRICT IMMUTABLE;
253 CREATE FUNCTION gin_compare_prefix_timestamptz(timestamptz, timestamptz, int2, internal)
256 LANGUAGE C STRICT IMMUTABLE;
258 CREATE FUNCTION gin_extract_query_timestamptz(timestamptz, internal, int2, internal, internal)
261 LANGUAGE C STRICT IMMUTABLE;
263 CREATE OPERATOR CLASS timestamptz_ops
264 DEFAULT FOR TYPE timestamptz USING gin
271 FUNCTION 1 timestamptz_cmp(timestamptz,timestamptz),
272 FUNCTION 2 gin_extract_value_timestamptz(timestamptz, internal),
273 FUNCTION 3 gin_extract_query_timestamptz(timestamptz, internal, int2, internal, internal),
274 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
275 FUNCTION 5 gin_compare_prefix_timestamptz(timestamptz,timestamptz,int2, internal),
278 CREATE FUNCTION gin_extract_value_time(time, internal)
281 LANGUAGE C STRICT IMMUTABLE;
283 CREATE FUNCTION gin_compare_prefix_time(time, time, int2, internal)
286 LANGUAGE C STRICT IMMUTABLE;
288 CREATE FUNCTION gin_extract_query_time(time, internal, int2, internal, internal)
291 LANGUAGE C STRICT IMMUTABLE;
293 CREATE OPERATOR CLASS time_ops
294 DEFAULT FOR TYPE time USING gin
301 FUNCTION 1 time_cmp(time,time),
302 FUNCTION 2 gin_extract_value_time(time, internal),
303 FUNCTION 3 gin_extract_query_time(time, internal, int2, internal, internal),
304 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
305 FUNCTION 5 gin_compare_prefix_time(time,time,int2, internal),
308 CREATE FUNCTION gin_extract_value_timetz(timetz, internal)
311 LANGUAGE C STRICT IMMUTABLE;
313 CREATE FUNCTION gin_compare_prefix_timetz(timetz, timetz, int2, internal)
316 LANGUAGE C STRICT IMMUTABLE;
318 CREATE FUNCTION gin_extract_query_timetz(timetz, internal, int2, internal, internal)
321 LANGUAGE C STRICT IMMUTABLE;
323 CREATE OPERATOR CLASS timetz_ops
324 DEFAULT FOR TYPE timetz USING gin
331 FUNCTION 1 timetz_cmp(timetz,timetz),
332 FUNCTION 2 gin_extract_value_timetz(timetz, internal),
333 FUNCTION 3 gin_extract_query_timetz(timetz, internal, int2, internal, internal),
334 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
335 FUNCTION 5 gin_compare_prefix_timetz(timetz,timetz,int2, internal),
338 CREATE FUNCTION gin_extract_value_date(date, internal)
341 LANGUAGE C STRICT IMMUTABLE;
343 CREATE FUNCTION gin_compare_prefix_date(date, date, int2, internal)
346 LANGUAGE C STRICT IMMUTABLE;
348 CREATE FUNCTION gin_extract_query_date(date, internal, int2, internal, internal)
351 LANGUAGE C STRICT IMMUTABLE;
353 CREATE OPERATOR CLASS date_ops
354 DEFAULT FOR TYPE date USING gin
361 FUNCTION 1 date_cmp(date,date),
362 FUNCTION 2 gin_extract_value_date(date, internal),
363 FUNCTION 3 gin_extract_query_date(date, internal, int2, internal, internal),
364 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
365 FUNCTION 5 gin_compare_prefix_date(date,date,int2, internal),
368 CREATE FUNCTION gin_extract_value_interval(interval, internal)
371 LANGUAGE C STRICT IMMUTABLE;
373 CREATE FUNCTION gin_compare_prefix_interval(interval, interval, int2, internal)
376 LANGUAGE C STRICT IMMUTABLE;
378 CREATE FUNCTION gin_extract_query_interval(interval, internal, int2, internal, internal)
381 LANGUAGE C STRICT IMMUTABLE;
383 CREATE OPERATOR CLASS interval_ops
384 DEFAULT FOR TYPE interval USING gin
391 FUNCTION 1 interval_cmp(interval,interval),
392 FUNCTION 2 gin_extract_value_interval(interval, internal),
393 FUNCTION 3 gin_extract_query_interval(interval, internal, int2, internal, internal),
394 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
395 FUNCTION 5 gin_compare_prefix_interval(interval,interval,int2, internal),
398 CREATE FUNCTION gin_extract_value_macaddr(macaddr, internal)
401 LANGUAGE C STRICT IMMUTABLE;
403 CREATE FUNCTION gin_compare_prefix_macaddr(macaddr, macaddr, int2, internal)
406 LANGUAGE C STRICT IMMUTABLE;
408 CREATE FUNCTION gin_extract_query_macaddr(macaddr, internal, int2, internal, internal)
411 LANGUAGE C STRICT IMMUTABLE;
413 CREATE OPERATOR CLASS macaddr_ops
414 DEFAULT FOR TYPE macaddr USING gin
421 FUNCTION 1 macaddr_cmp(macaddr,macaddr),
422 FUNCTION 2 gin_extract_value_macaddr(macaddr, internal),
423 FUNCTION 3 gin_extract_query_macaddr(macaddr, internal, int2, internal, internal),
424 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
425 FUNCTION 5 gin_compare_prefix_macaddr(macaddr,macaddr,int2, internal),
428 CREATE FUNCTION gin_extract_value_inet(inet, internal)
431 LANGUAGE C STRICT IMMUTABLE;
433 CREATE FUNCTION gin_compare_prefix_inet(inet, inet, int2, internal)
436 LANGUAGE C STRICT IMMUTABLE;
438 CREATE FUNCTION gin_extract_query_inet(inet, internal, int2, internal, internal)
441 LANGUAGE C STRICT IMMUTABLE;
443 CREATE OPERATOR CLASS inet_ops
444 DEFAULT FOR TYPE inet USING gin
451 FUNCTION 1 network_cmp(inet,inet),
452 FUNCTION 2 gin_extract_value_inet(inet, internal),
453 FUNCTION 3 gin_extract_query_inet(inet, internal, int2, internal, internal),
454 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
455 FUNCTION 5 gin_compare_prefix_inet(inet,inet,int2, internal),
458 CREATE FUNCTION gin_extract_value_cidr(cidr, internal)
461 LANGUAGE C STRICT IMMUTABLE;
463 CREATE FUNCTION gin_compare_prefix_cidr(cidr, cidr, int2, internal)
466 LANGUAGE C STRICT IMMUTABLE;
468 CREATE FUNCTION gin_extract_query_cidr(cidr, internal, int2, internal, internal)
471 LANGUAGE C STRICT IMMUTABLE;
473 CREATE OPERATOR CLASS cidr_ops
474 DEFAULT FOR TYPE cidr USING gin
476 OPERATOR 1 <(inet,inet),
477 OPERATOR 2 <=(inet,inet),
478 OPERATOR 3 =(inet,inet),
479 OPERATOR 4 >=(inet,inet),
480 OPERATOR 5 >(inet,inet),
481 FUNCTION 1 network_cmp(inet,inet),
482 FUNCTION 2 gin_extract_value_cidr(cidr, internal),
483 FUNCTION 3 gin_extract_query_cidr(cidr, internal, int2, internal, internal),
484 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
485 FUNCTION 5 gin_compare_prefix_cidr(cidr,cidr,int2, internal),
488 CREATE FUNCTION gin_extract_value_text(text, internal)
491 LANGUAGE C STRICT IMMUTABLE;
493 CREATE FUNCTION gin_compare_prefix_text(text, text, int2, internal)
496 LANGUAGE C STRICT IMMUTABLE;
498 CREATE FUNCTION gin_extract_query_text(text, internal, int2, internal, internal)
501 LANGUAGE C STRICT IMMUTABLE;
503 CREATE OPERATOR CLASS text_ops
504 DEFAULT FOR TYPE text USING gin
511 FUNCTION 1 bttextcmp(text,text),
512 FUNCTION 2 gin_extract_value_text(text, internal),
513 FUNCTION 3 gin_extract_query_text(text, internal, int2, internal, internal),
514 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
515 FUNCTION 5 gin_compare_prefix_text(text,text,int2, internal),
518 CREATE OPERATOR CLASS varchar_ops
519 DEFAULT FOR TYPE varchar USING gin
521 OPERATOR 1 <(text,text),
522 OPERATOR 2 <=(text,text),
523 OPERATOR 3 =(text,text),
524 OPERATOR 4 >=(text,text),
525 OPERATOR 5 >(text,text),
526 FUNCTION 1 bttextcmp(text,text),
527 FUNCTION 2 gin_extract_value_text(text, internal),
528 FUNCTION 3 gin_extract_query_text(text, internal, int2, internal, internal),
529 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
530 FUNCTION 5 gin_compare_prefix_text(text,text,int2, internal),
533 CREATE FUNCTION gin_extract_value_char("char", internal)
536 LANGUAGE C STRICT IMMUTABLE;
538 CREATE FUNCTION gin_compare_prefix_char("char", "char", int2, internal)
541 LANGUAGE C STRICT IMMUTABLE;
543 CREATE FUNCTION gin_extract_query_char("char", internal, int2, internal, internal)
546 LANGUAGE C STRICT IMMUTABLE;
548 CREATE OPERATOR CLASS char_ops
549 DEFAULT FOR TYPE "char" USING gin
556 FUNCTION 1 btcharcmp("char","char"),
557 FUNCTION 2 gin_extract_value_char("char", internal),
558 FUNCTION 3 gin_extract_query_char("char", internal, int2, internal, internal),
559 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
560 FUNCTION 5 gin_compare_prefix_char("char","char",int2, internal),
563 CREATE FUNCTION gin_extract_value_bytea(bytea, internal)
566 LANGUAGE C STRICT IMMUTABLE;
568 CREATE FUNCTION gin_compare_prefix_bytea(bytea, bytea, int2, internal)
571 LANGUAGE C STRICT IMMUTABLE;
573 CREATE FUNCTION gin_extract_query_bytea(bytea, internal, int2, internal, internal)
576 LANGUAGE C STRICT IMMUTABLE;
578 CREATE OPERATOR CLASS bytea_ops
579 DEFAULT FOR TYPE bytea USING gin
586 FUNCTION 1 byteacmp(bytea,bytea),
587 FUNCTION 2 gin_extract_value_bytea(bytea, internal),
588 FUNCTION 3 gin_extract_query_bytea(bytea, internal, int2, internal, internal),
589 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
590 FUNCTION 5 gin_compare_prefix_bytea(bytea,bytea,int2, internal),
593 CREATE FUNCTION gin_extract_value_bit(bit, internal)
596 LANGUAGE C STRICT IMMUTABLE;
598 CREATE FUNCTION gin_compare_prefix_bit(bit, bit, int2, internal)
601 LANGUAGE C STRICT IMMUTABLE;
603 CREATE FUNCTION gin_extract_query_bit(bit, internal, int2, internal, internal)
606 LANGUAGE C STRICT IMMUTABLE;
608 CREATE OPERATOR CLASS bit_ops
609 DEFAULT FOR TYPE bit USING gin
616 FUNCTION 1 bitcmp(bit,bit),
617 FUNCTION 2 gin_extract_value_bit(bit, internal),
618 FUNCTION 3 gin_extract_query_bit(bit, internal, int2, internal, internal),
619 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
620 FUNCTION 5 gin_compare_prefix_bit(bit,bit,int2, internal),
623 CREATE FUNCTION gin_extract_value_varbit(varbit, internal)
626 LANGUAGE C STRICT IMMUTABLE;
628 CREATE FUNCTION gin_compare_prefix_varbit(varbit, varbit, int2, internal)
631 LANGUAGE C STRICT IMMUTABLE;
633 CREATE FUNCTION gin_extract_query_varbit(varbit, internal, int2, internal, internal)
636 LANGUAGE C STRICT IMMUTABLE;
638 CREATE OPERATOR CLASS varbit_ops
639 DEFAULT FOR TYPE varbit USING gin
646 FUNCTION 1 varbitcmp(varbit,varbit),
647 FUNCTION 2 gin_extract_value_varbit(varbit, internal),
648 FUNCTION 3 gin_extract_query_varbit(varbit, internal, int2, internal, internal),
649 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
650 FUNCTION 5 gin_compare_prefix_varbit(varbit,varbit,int2, internal),
653 CREATE FUNCTION gin_extract_value_numeric(numeric, internal)
656 LANGUAGE C STRICT IMMUTABLE;
658 CREATE FUNCTION gin_compare_prefix_numeric(numeric, numeric, int2, internal)
661 LANGUAGE C STRICT IMMUTABLE;
663 CREATE FUNCTION gin_extract_query_numeric(numeric, internal, int2, internal, internal)
666 LANGUAGE C STRICT IMMUTABLE;
668 CREATE FUNCTION gin_numeric_cmp(numeric, numeric)
671 LANGUAGE C STRICT IMMUTABLE;
673 CREATE OPERATOR CLASS numeric_ops
674 DEFAULT FOR TYPE numeric USING gin
681 FUNCTION 1 gin_numeric_cmp(numeric,numeric),
682 FUNCTION 2 gin_extract_value_numeric(numeric, internal),
683 FUNCTION 3 gin_extract_query_numeric(numeric, internal, int2, internal, internal),
684 FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal),
685 FUNCTION 5 gin_compare_prefix_numeric(numeric,numeric,int2, internal),