Server IP : 85.214.239.14 / Your IP : 18.224.60.132 Web Server : Apache/2.4.62 (Debian) System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.18 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /proc/self/root/proc/2/cwd/usr/share/postgresql/9.6/extension/ |
Upload File : |
/* contrib/btree_gin/btree_gin--1.0.sql */ -- complain if script is sourced in psql, rather than via CREATE EXTENSION \echo Use "CREATE EXTENSION btree_gin" to load this file. \quit CREATE FUNCTION gin_btree_consistent(internal, int2, anyelement, int4, internal, internal) RETURNS bool AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_value_int2(int2, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_compare_prefix_int2(int2, int2, int2, internal) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_query_int2(int2, internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE OPERATOR CLASS int2_ops DEFAULT FOR TYPE int2 USING gin AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 btint2cmp(int2,int2), FUNCTION 2 gin_extract_value_int2(int2, internal), FUNCTION 3 gin_extract_query_int2(int2, internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_int2(int2,int2,int2, internal), STORAGE int2; CREATE FUNCTION gin_extract_value_int4(int4, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_compare_prefix_int4(int4, int4, int2, internal) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_query_int4(int4, internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE OPERATOR CLASS int4_ops DEFAULT FOR TYPE int4 USING gin AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 btint4cmp(int4,int4), FUNCTION 2 gin_extract_value_int4(int4, internal), FUNCTION 3 gin_extract_query_int4(int4, internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_int4(int4,int4,int2, internal), STORAGE int4; CREATE FUNCTION gin_extract_value_int8(int8, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_compare_prefix_int8(int8, int8, int2, internal) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_query_int8(int8, internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE OPERATOR CLASS int8_ops DEFAULT FOR TYPE int8 USING gin AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 btint8cmp(int8,int8), FUNCTION 2 gin_extract_value_int8(int8, internal), FUNCTION 3 gin_extract_query_int8(int8, internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_int8(int8,int8,int2, internal), STORAGE int8; CREATE FUNCTION gin_extract_value_float4(float4, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_compare_prefix_float4(float4, float4, int2, internal) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_query_float4(float4, internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE OPERATOR CLASS float4_ops DEFAULT FOR TYPE float4 USING gin AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 btfloat4cmp(float4,float4), FUNCTION 2 gin_extract_value_float4(float4, internal), FUNCTION 3 gin_extract_query_float4(float4, internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_float4(float4,float4,int2, internal), STORAGE float4; CREATE FUNCTION gin_extract_value_float8(float8, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_compare_prefix_float8(float8, float8, int2, internal) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_query_float8(float8, internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE OPERATOR CLASS float8_ops DEFAULT FOR TYPE float8 USING gin AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 btfloat8cmp(float8,float8), FUNCTION 2 gin_extract_value_float8(float8, internal), FUNCTION 3 gin_extract_query_float8(float8, internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_float8(float8,float8,int2, internal), STORAGE float8; CREATE FUNCTION gin_extract_value_money(money, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_compare_prefix_money(money, money, int2, internal) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_query_money(money, internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE OPERATOR CLASS money_ops DEFAULT FOR TYPE money USING gin AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 cash_cmp(money,money), FUNCTION 2 gin_extract_value_money(money, internal), FUNCTION 3 gin_extract_query_money(money, internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_money(money,money,int2, internal), STORAGE money; CREATE FUNCTION gin_extract_value_oid(oid, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_compare_prefix_oid(oid, oid, int2, internal) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_query_oid(oid, internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE OPERATOR CLASS oid_ops DEFAULT FOR TYPE oid USING gin AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 btoidcmp(oid,oid), FUNCTION 2 gin_extract_value_oid(oid, internal), FUNCTION 3 gin_extract_query_oid(oid, internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_oid(oid,oid,int2, internal), STORAGE oid; CREATE FUNCTION gin_extract_value_timestamp(timestamp, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_compare_prefix_timestamp(timestamp, timestamp, int2, internal) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_query_timestamp(timestamp, internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE OPERATOR CLASS timestamp_ops DEFAULT FOR TYPE timestamp USING gin AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 timestamp_cmp(timestamp,timestamp), FUNCTION 2 gin_extract_value_timestamp(timestamp, internal), FUNCTION 3 gin_extract_query_timestamp(timestamp, internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_timestamp(timestamp,timestamp,int2, internal), STORAGE timestamp; CREATE FUNCTION gin_extract_value_timestamptz(timestamptz, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_compare_prefix_timestamptz(timestamptz, timestamptz, int2, internal) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_query_timestamptz(timestamptz, internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE OPERATOR CLASS timestamptz_ops DEFAULT FOR TYPE timestamptz USING gin AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 timestamptz_cmp(timestamptz,timestamptz), FUNCTION 2 gin_extract_value_timestamptz(timestamptz, internal), FUNCTION 3 gin_extract_query_timestamptz(timestamptz, internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_timestamptz(timestamptz,timestamptz,int2, internal), STORAGE timestamptz; CREATE FUNCTION gin_extract_value_time(time, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_compare_prefix_time(time, time, int2, internal) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_query_time(time, internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE OPERATOR CLASS time_ops DEFAULT FOR TYPE time USING gin AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 time_cmp(time,time), FUNCTION 2 gin_extract_value_time(time, internal), FUNCTION 3 gin_extract_query_time(time, internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_time(time,time,int2, internal), STORAGE time; CREATE FUNCTION gin_extract_value_timetz(timetz, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_compare_prefix_timetz(timetz, timetz, int2, internal) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_query_timetz(timetz, internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE OPERATOR CLASS timetz_ops DEFAULT FOR TYPE timetz USING gin AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 timetz_cmp(timetz,timetz), FUNCTION 2 gin_extract_value_timetz(timetz, internal), FUNCTION 3 gin_extract_query_timetz(timetz, internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_timetz(timetz,timetz,int2, internal), STORAGE timetz; CREATE FUNCTION gin_extract_value_date(date, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_compare_prefix_date(date, date, int2, internal) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_query_date(date, internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE OPERATOR CLASS date_ops DEFAULT FOR TYPE date USING gin AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 date_cmp(date,date), FUNCTION 2 gin_extract_value_date(date, internal), FUNCTION 3 gin_extract_query_date(date, internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_date(date,date,int2, internal), STORAGE date; CREATE FUNCTION gin_extract_value_interval(interval, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_compare_prefix_interval(interval, interval, int2, internal) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_query_interval(interval, internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE OPERATOR CLASS interval_ops DEFAULT FOR TYPE interval USING gin AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 interval_cmp(interval,interval), FUNCTION 2 gin_extract_value_interval(interval, internal), FUNCTION 3 gin_extract_query_interval(interval, internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_interval(interval,interval,int2, internal), STORAGE interval; CREATE FUNCTION gin_extract_value_macaddr(macaddr, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_compare_prefix_macaddr(macaddr, macaddr, int2, internal) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_query_macaddr(macaddr, internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE OPERATOR CLASS macaddr_ops DEFAULT FOR TYPE macaddr USING gin AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 macaddr_cmp(macaddr,macaddr), FUNCTION 2 gin_extract_value_macaddr(macaddr, internal), FUNCTION 3 gin_extract_query_macaddr(macaddr, internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_macaddr(macaddr,macaddr,int2, internal), STORAGE macaddr; CREATE FUNCTION gin_extract_value_inet(inet, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_compare_prefix_inet(inet, inet, int2, internal) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_query_inet(inet, internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE OPERATOR CLASS inet_ops DEFAULT FOR TYPE inet USING gin AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 network_cmp(inet,inet), FUNCTION 2 gin_extract_value_inet(inet, internal), FUNCTION 3 gin_extract_query_inet(inet, internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_inet(inet,inet,int2, internal), STORAGE inet; CREATE FUNCTION gin_extract_value_cidr(cidr, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_compare_prefix_cidr(cidr, cidr, int2, internal) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_query_cidr(cidr, internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE OPERATOR CLASS cidr_ops DEFAULT FOR TYPE cidr USING gin AS OPERATOR 1 <(inet,inet), OPERATOR 2 <=(inet,inet), OPERATOR 3 =(inet,inet), OPERATOR 4 >=(inet,inet), OPERATOR 5 >(inet,inet), FUNCTION 1 network_cmp(inet,inet), FUNCTION 2 gin_extract_value_cidr(cidr, internal), FUNCTION 3 gin_extract_query_cidr(cidr, internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_cidr(cidr,cidr,int2, internal), STORAGE cidr; CREATE FUNCTION gin_extract_value_text(text, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_compare_prefix_text(text, text, int2, internal) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_query_text(text, internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE OPERATOR CLASS text_ops DEFAULT FOR TYPE text USING gin AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 bttextcmp(text,text), FUNCTION 2 gin_extract_value_text(text, internal), FUNCTION 3 gin_extract_query_text(text, internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_text(text,text,int2, internal), STORAGE text; CREATE OPERATOR CLASS varchar_ops DEFAULT FOR TYPE varchar USING gin AS OPERATOR 1 <(text,text), OPERATOR 2 <=(text,text), OPERATOR 3 =(text,text), OPERATOR 4 >=(text,text), OPERATOR 5 >(text,text), FUNCTION 1 bttextcmp(text,text), FUNCTION 2 gin_extract_value_text(text, internal), FUNCTION 3 gin_extract_query_text(text, internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_text(text,text,int2, internal), STORAGE varchar; CREATE FUNCTION gin_extract_value_char("char", internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_compare_prefix_char("char", "char", int2, internal) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_query_char("char", internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE OPERATOR CLASS char_ops DEFAULT FOR TYPE "char" USING gin AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 btcharcmp("char","char"), FUNCTION 2 gin_extract_value_char("char", internal), FUNCTION 3 gin_extract_query_char("char", internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_char("char","char",int2, internal), STORAGE "char"; CREATE FUNCTION gin_extract_value_bytea(bytea, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_compare_prefix_bytea(bytea, bytea, int2, internal) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_query_bytea(bytea, internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE OPERATOR CLASS bytea_ops DEFAULT FOR TYPE bytea USING gin AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 byteacmp(bytea,bytea), FUNCTION 2 gin_extract_value_bytea(bytea, internal), FUNCTION 3 gin_extract_query_bytea(bytea, internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_bytea(bytea,bytea,int2, internal), STORAGE bytea; CREATE FUNCTION gin_extract_value_bit(bit, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_compare_prefix_bit(bit, bit, int2, internal) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_query_bit(bit, internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE OPERATOR CLASS bit_ops DEFAULT FOR TYPE bit USING gin AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 bitcmp(bit,bit), FUNCTION 2 gin_extract_value_bit(bit, internal), FUNCTION 3 gin_extract_query_bit(bit, internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_bit(bit,bit,int2, internal), STORAGE bit; CREATE FUNCTION gin_extract_value_varbit(varbit, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_compare_prefix_varbit(varbit, varbit, int2, internal) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_query_varbit(varbit, internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE OPERATOR CLASS varbit_ops DEFAULT FOR TYPE varbit USING gin AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 varbitcmp(varbit,varbit), FUNCTION 2 gin_extract_value_varbit(varbit, internal), FUNCTION 3 gin_extract_query_varbit(varbit, internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_varbit(varbit,varbit,int2, internal), STORAGE varbit; CREATE FUNCTION gin_extract_value_numeric(numeric, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_compare_prefix_numeric(numeric, numeric, int2, internal) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_extract_query_numeric(numeric, internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE FUNCTION gin_numeric_cmp(numeric, numeric) RETURNS int4 AS 'MODULE_PATHNAME' LANGUAGE C STRICT IMMUTABLE; CREATE OPERATOR CLASS numeric_ops DEFAULT FOR TYPE numeric USING gin AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 gin_numeric_cmp(numeric,numeric), FUNCTION 2 gin_extract_value_numeric(numeric, internal), FUNCTION 3 gin_extract_query_numeric(numeric, internal, int2, internal, internal), FUNCTION 4 gin_btree_consistent(internal, int2, anyelement, int4, internal, internal), FUNCTION 5 gin_compare_prefix_numeric(numeric,numeric,int2, internal), STORAGE numeric;