Routines

Routines

Name Type Language Deterministic Return Type Security Restriction Comments
gbt_timetz_compress(internal) FUNCTION c true internal INVOKER
gbt_uuid_fetch(internal) FUNCTION c true internal INVOKER
gbt_bool_union(internal, internal) FUNCTION c true gbtreekey2 INVOKER
gbt_uuid_picksplit(internal, internal) FUNCTION c true internal INVOKER
uuid_generate_v5(namespace uuid, name text) FUNCTION c true uuid INVOKER
gbt_var_fetch(internal) FUNCTION c true internal INVOKER
uuid_ns_dns() FUNCTION c true uuid INVOKER
gbt_int2_consistent(internal, smallint, smallint, oid, internal) FUNCTION c true boolean INVOKER
gbt_date_fetch(internal) FUNCTION c true internal INVOKER
gbt_ts_distance(internal, timestamp without time zone, smallint, oid, internal) FUNCTION c true double precision INVOKER
gbt_inet_same(gbtreekey16, gbtreekey16, internal) FUNCTION c true internal INVOKER
gbtreekey_var_out(gbtreekey_var) FUNCTION c true cstring INVOKER
gbt_oid_picksplit(internal, internal) FUNCTION c true internal INVOKER
gbt_macad_same(gbtreekey16, gbtreekey16, internal) FUNCTION c true internal INVOKER
gbt_enum_penalty(internal, internal, internal) FUNCTION c true internal INVOKER
gbt_date_union(internal, internal) FUNCTION c true gbtreekey8 INVOKER
gbt_int4_fetch(internal) FUNCTION c true internal INVOKER
gbt_int8_same(gbtreekey16, gbtreekey16, internal) FUNCTION c true internal INVOKER
gbt_enum_compress(internal) FUNCTION c true internal INVOKER
gbt_bpchar_compress(internal) FUNCTION c true internal INVOKER
interval_dist(interval, interval) FUNCTION c true interval INVOKER
gbt_cash_distance(internal, money, smallint, oid, internal) FUNCTION c true double precision INVOKER
int4_dist(integer, integer) FUNCTION c true integer INVOKER
gbt_uuid_compress(internal) FUNCTION c true internal INVOKER
gbt_macad_union(internal, internal) FUNCTION c true gbtreekey16 INVOKER
gbt_float8_compress(internal) FUNCTION c true internal INVOKER
gbt_ts_penalty(internal, internal, internal) FUNCTION c true internal INVOKER
gbt_cash_consistent(internal, money, smallint, oid, internal) FUNCTION c true boolean INVOKER
uuid_ns_oid() FUNCTION c true uuid INVOKER
gbt_float8_picksplit(internal, internal) FUNCTION c true internal INVOKER
gbt_int8_compress(internal) FUNCTION c true internal INVOKER
gbt_numeric_same(gbtreekey_var, gbtreekey_var, internal) FUNCTION c true internal INVOKER
gbt_time_fetch(internal) FUNCTION c true internal INVOKER
gbt_int2_penalty(internal, internal, internal) FUNCTION c true internal INVOKER
gbt_enum_fetch(internal) FUNCTION c true internal INVOKER
gbt_macad8_picksplit(internal, internal) FUNCTION c true internal INVOKER
gbt_cash_fetch(internal) FUNCTION c true internal INVOKER
uuid_ns_url() FUNCTION c true uuid INVOKER
gbt_ts_fetch(internal) FUNCTION c true internal INVOKER
float4_dist(real, real) FUNCTION c true real INVOKER
gbt_int4_picksplit(internal, internal) FUNCTION c true internal INVOKER
gbt_bytea_union(internal, internal) FUNCTION c true gbtreekey_var INVOKER
gbt_ts_same(gbtreekey16, gbtreekey16, internal) FUNCTION c true internal INVOKER
gbt_intv_compress(internal) FUNCTION c true internal INVOKER
gbt_int8_distance(internal, bigint, smallint, oid, internal) FUNCTION c true double precision INVOKER
gbt_uuid_union(internal, internal) FUNCTION c true gbtreekey32 INVOKER
gbt_oid_union(internal, internal) FUNCTION c true gbtreekey8 INVOKER
gbt_float8_fetch(internal) FUNCTION c true internal INVOKER
gbt_bytea_consistent(internal, bytea, smallint, oid, internal) FUNCTION c true boolean INVOKER
gbt_numeric_compress(internal) FUNCTION c true internal INVOKER
gbt_var_decompress(internal) FUNCTION c true internal INVOKER
gbt_bool_fetch(internal) FUNCTION c true internal INVOKER
gbt_intv_union(internal, internal) FUNCTION c true gbtreekey32 INVOKER
gbt_inet_penalty(internal, internal, internal) FUNCTION c true internal INVOKER
float8_dist(double precision, double precision) FUNCTION c true double precision INVOKER
gbtreekey4_out(gbtreekey4) FUNCTION c true cstring INVOKER
gbt_macad8_same(gbtreekey16, gbtreekey16, internal) FUNCTION c true internal INVOKER
gbt_int2_distance(internal, smallint, smallint, oid, internal) FUNCTION c true double precision INVOKER
gbt_macad8_penalty(internal, internal, internal) FUNCTION c true internal INVOKER
gbtreekey2_out(gbtreekey2) FUNCTION c true cstring INVOKER
int8_dist(bigint, bigint) FUNCTION c true bigint INVOKER
get_tyyppi(polku text, tyyppi text) FUNCTION sql false TABLE(versio_tunniste uuid, data jsonb) INVOKER
gbt_text_same(gbtreekey_var, gbtreekey_var, internal) FUNCTION c true internal INVOKER
gbt_intv_same(gbtreekey32, gbtreekey32, internal) FUNCTION c true internal INVOKER
gbt_macad8_compress(internal) FUNCTION c true internal INVOKER
gbt_int2_picksplit(internal, internal) FUNCTION c true internal INVOKER
gbt_int4_penalty(internal, internal, internal) FUNCTION c true internal INVOKER
gbt_float8_distance(internal, double precision, smallint, oid, internal) FUNCTION c true double precision INVOKER
gbt_float8_penalty(internal, internal, internal) FUNCTION c true internal INVOKER
gbt_date_picksplit(internal, internal) FUNCTION c true internal INVOKER
gbt_oid_penalty(internal, internal, internal) FUNCTION c true internal INVOKER
gbt_oid_compress(internal) FUNCTION c true internal INVOKER
gbt_bool_penalty(internal, internal, internal) FUNCTION c true internal INVOKER
uuid_ns_x500() FUNCTION c true uuid INVOKER
gbt_time_penalty(internal, internal, internal) FUNCTION c true internal INVOKER
gbt_decompress(internal) FUNCTION c true internal INVOKER
gbt_enum_union(internal, internal) FUNCTION c true gbtreekey8 INVOKER
gbt_intv_picksplit(internal, internal) FUNCTION c true internal INVOKER
gbt_float8_union(internal, internal) FUNCTION c true gbtreekey16 INVOKER
gbt_bytea_compress(internal) FUNCTION c true internal INVOKER
gbt_intv_distance(internal, interval, smallint, oid, internal) FUNCTION c true double precision INVOKER
gbt_bool_compress(internal) FUNCTION c true internal INVOKER
gbt_tstz_consistent(internal, timestamp with time zone, smallint, oid, internal) FUNCTION c true boolean INVOKER
gbt_numeric_consistent(internal, numeric, smallint, oid, internal) FUNCTION c true boolean INVOKER
gbtreekey16_out(gbtreekey16) FUNCTION c true cstring INVOKER
gbt_float4_distance(internal, real, smallint, oid, internal) FUNCTION c true double precision INVOKER
gbt_inet_compress(internal) FUNCTION c true internal INVOKER
time_dist(time without time zone, time without time zone) FUNCTION c true interval INVOKER
gbt_uuid_same(gbtreekey32, gbtreekey32, internal) FUNCTION c true internal INVOKER
gbtreekey16_in(cstring) FUNCTION c true gbtreekey16 INVOKER
gbt_int4_consistent(internal, integer, smallint, oid, internal) FUNCTION c true boolean INVOKER
gbt_int2_same(gbtreekey4, gbtreekey4, internal) FUNCTION c true internal INVOKER
gbt_cash_compress(internal) FUNCTION c true internal INVOKER
gbt_bit_union(internal, internal) FUNCTION c true gbtreekey_var INVOKER
gbt_oid_fetch(internal) FUNCTION c true internal INVOKER
gbt_tstz_compress(internal) FUNCTION c true internal INVOKER
uuid_generate_v3(namespace uuid, name text) FUNCTION c true uuid INVOKER
uuid_generate_v1mc() FUNCTION c false uuid INVOKER
gbtreekey32_in(cstring) FUNCTION c true gbtreekey32 INVOKER
gbt_bytea_same(gbtreekey_var, gbtreekey_var, internal) FUNCTION c true internal INVOKER
gbt_numeric_picksplit(internal, internal) FUNCTION c true internal INVOKER
gbt_numeric_penalty(internal, internal, internal) FUNCTION c true internal INVOKER
gbt_bool_same(gbtreekey2, gbtreekey2, internal) FUNCTION c true internal INVOKER
gbt_float4_union(internal, internal) FUNCTION c true gbtreekey8 INVOKER
uuid_nil() FUNCTION c true uuid INVOKER
gbt_float4_fetch(internal) FUNCTION c true internal INVOKER
gbt_bytea_penalty(internal, internal, internal) FUNCTION c true internal INVOKER
gbt_cash_picksplit(internal, internal) FUNCTION c true internal INVOKER
gbt_float4_compress(internal) FUNCTION c true internal INVOKER
gbt_uuid_penalty(internal, internal, internal) FUNCTION c true internal INVOKER
gbt_bool_picksplit(internal, internal) FUNCTION c true internal INVOKER
gbt_enum_same(gbtreekey8, gbtreekey8, internal) FUNCTION c true internal INVOKER
gbt_oid_distance(internal, oid, smallint, oid, internal) FUNCTION c true double precision INVOKER
tstz_dist(timestamp with time zone, timestamp with time zone) FUNCTION c true interval INVOKER
date_dist(date, date) FUNCTION c true integer INVOKER
gbt_enum_picksplit(internal, internal) FUNCTION c true internal INVOKER
gbt_ts_picksplit(internal, internal) FUNCTION c true internal INVOKER
gbt_bit_same(gbtreekey_var, gbtreekey_var, internal) FUNCTION c true internal INVOKER
gbt_intv_penalty(internal, internal, internal) FUNCTION c true internal INVOKER
gbt_bytea_picksplit(internal, internal) FUNCTION c true internal INVOKER
gbt_time_picksplit(internal, internal) FUNCTION c true internal INVOKER
gbt_int2_compress(internal) FUNCTION c true internal INVOKER
gbt_int4_compress(internal) FUNCTION c true internal INVOKER
gbt_date_compress(internal) FUNCTION c true internal INVOKER
gbt_bit_picksplit(internal, internal) FUNCTION c true internal INVOKER
uuid_generate_v4() FUNCTION c false uuid INVOKER
gbt_inet_union(internal, internal) FUNCTION c true gbtreekey16 INVOKER
gbt_float4_same(gbtreekey8, gbtreekey8, internal) FUNCTION c true internal INVOKER
gbtreekey2_in(cstring) FUNCTION c true gbtreekey2 INVOKER
cash_dist(money, money) FUNCTION c true money INVOKER
gbt_text_compress(internal) FUNCTION c true internal INVOKER
gbt_float8_same(gbtreekey16, gbtreekey16, internal) FUNCTION c true internal INVOKER
gbt_bit_consistent(internal, bit, smallint, oid, internal) FUNCTION c true boolean INVOKER
gbt_date_distance(internal, date, smallint, oid, internal) FUNCTION c true double precision INVOKER
gbt_macad8_consistent(internal, macaddr8, smallint, oid, internal) FUNCTION c true boolean INVOKER
gbtreekey4_in(cstring) FUNCTION c true gbtreekey4 INVOKER
gbt_int8_union(internal, internal) FUNCTION c true gbtreekey16 INVOKER
gbt_enum_consistent(internal, anyenum, smallint, oid, internal) FUNCTION c true boolean INVOKER
gbtreekey8_in(cstring) FUNCTION c true gbtreekey8 INVOKER
gbt_date_same(gbtreekey8, gbtreekey8, internal) FUNCTION c true internal INVOKER
gbt_int4_same(gbtreekey8, gbtreekey8, internal) FUNCTION c true internal INVOKER
gbt_date_consistent(internal, date, smallint, oid, internal) FUNCTION c true boolean INVOKER
gbt_intv_consistent(internal, interval, smallint, oid, internal) FUNCTION c true boolean INVOKER
gbt_float8_consistent(internal, double precision, smallint, oid, internal) FUNCTION c true boolean INVOKER
gbt_date_penalty(internal, internal, internal) FUNCTION c true internal INVOKER
gbt_time_same(gbtreekey16, gbtreekey16, internal) FUNCTION c true internal INVOKER
ts_dist(timestamp without time zone, timestamp without time zone) FUNCTION c true interval INVOKER
gbt_macad_penalty(internal, internal, internal) FUNCTION c true internal INVOKER
gbt_int2_fetch(internal) FUNCTION c true internal INVOKER
gbt_text_union(internal, internal) FUNCTION c true gbtreekey_var INVOKER
gbtreekey_var_in(cstring) FUNCTION c true gbtreekey_var INVOKER
uuid_generate_v1() FUNCTION c false uuid INVOKER
gbt_int8_fetch(internal) FUNCTION c true internal INVOKER
gbt_float4_consistent(internal, real, smallint, oid, internal) FUNCTION c true boolean INVOKER
gbt_ts_union(internal, internal) FUNCTION c true gbtreekey16 INVOKER
gbt_macad_fetch(internal) FUNCTION c true internal INVOKER
gbt_bpchar_consistent(internal, character, smallint, oid, internal) FUNCTION c true boolean INVOKER
gbt_time_distance(internal, time without time zone, smallint, oid, internal) FUNCTION c true double precision INVOKER
gbt_macad8_fetch(internal) FUNCTION c true internal INVOKER
gbt_time_union(internal, internal) FUNCTION c true gbtreekey16 INVOKER
gbt_macad_consistent(internal, macaddr, smallint, oid, internal) FUNCTION c true boolean INVOKER
gbt_text_consistent(internal, text, smallint, oid, internal) FUNCTION c true boolean INVOKER
gbt_time_consistent(internal, time without time zone, smallint, oid, internal) FUNCTION c true boolean INVOKER
gbt_inet_consistent(internal, inet, smallint, oid, internal) FUNCTION c true boolean INVOKER
gbt_bit_compress(internal) FUNCTION c true internal INVOKER
gbt_int8_penalty(internal, internal, internal) FUNCTION c true internal INVOKER
gbt_ts_consistent(internal, timestamp without time zone, smallint, oid, internal) FUNCTION c true boolean INVOKER
int2_dist(smallint, smallint) FUNCTION c true smallint INVOKER
gbt_timetz_consistent(internal, time with time zone, smallint, oid, internal) FUNCTION c true boolean INVOKER
gbt_float4_penalty(internal, internal, internal) FUNCTION c true internal INVOKER
gbt_inet_picksplit(internal, internal) FUNCTION c true internal INVOKER
gbt_text_picksplit(internal, internal) FUNCTION c true internal INVOKER
gbt_cash_penalty(internal, internal, internal) FUNCTION c true internal INVOKER
gbt_intv_fetch(internal) FUNCTION c true internal INVOKER
gbt_int8_picksplit(internal, internal) FUNCTION c true internal INVOKER
gbt_int4_union(internal, internal) FUNCTION c true gbtreekey8 INVOKER
gbt_tstz_distance(internal, timestamp with time zone, smallint, oid, internal) FUNCTION c true double precision INVOKER
gbt_macad_picksplit(internal, internal) FUNCTION c true internal INVOKER
gbtreekey32_out(gbtreekey32) FUNCTION c true cstring INVOKER
gbt_bit_penalty(internal, internal, internal) FUNCTION c true internal INVOKER
gbt_text_penalty(internal, internal, internal) FUNCTION c true internal INVOKER
gbt_macad_compress(internal) FUNCTION c true internal INVOKER
gbt_intv_decompress(internal) FUNCTION c true internal INVOKER
gbt_float4_picksplit(internal, internal) FUNCTION c true internal INVOKER
gbt_uuid_consistent(internal, uuid, smallint, oid, internal) FUNCTION c true boolean INVOKER
gbt_ts_compress(internal) FUNCTION c true internal INVOKER
gbtreekey8_out(gbtreekey8) FUNCTION c true cstring INVOKER
gbt_int8_consistent(internal, bigint, smallint, oid, internal) FUNCTION c true boolean INVOKER
oid_dist(oid, oid) FUNCTION c true oid INVOKER
gbt_bool_consistent(internal, boolean, smallint, oid, internal) FUNCTION c true boolean INVOKER
gbt_oid_same(gbtreekey8, gbtreekey8, internal) FUNCTION c true internal INVOKER
gbt_cash_same(gbtreekey16, gbtreekey16, internal) FUNCTION c true internal INVOKER
gbt_time_compress(internal) FUNCTION c true internal INVOKER
gbt_int2_union(internal, internal) FUNCTION c true gbtreekey4 INVOKER
gbt_oid_consistent(internal, oid, smallint, oid, internal) FUNCTION c true boolean INVOKER
gbt_int4_distance(internal, integer, smallint, oid, internal) FUNCTION c true double precision INVOKER
gbt_cash_union(internal, internal) FUNCTION c true gbtreekey16 INVOKER
gbt_macad8_union(internal, internal) FUNCTION c true gbtreekey16 INVOKER
gbt_numeric_union(internal, internal) FUNCTION c true gbtreekey_var INVOKER