内部函数
Vastbase中下列函数使用了内部数据类型,用户无法直接调用,在此章节列出。
选择率计算函数
areajoinsel
|
areasel
|
arraycontjoinsel
|
arraycontsel
|
contjoinsel
|
contsel
|
eqjoinsel
|
eqsel
|
iclikejoinsel
|
iclikesel
|
icnlikejoinsel
|
icnlikesel
|
icregexeqjoinsel
|
icregexeqsel
|
icregexnejoinsel
|
icregexnesel
|
likejoinsel
|
likesel
|
neqjoinsel
|
neqsel
|
nlikejoinsel
|
nlikesel
|
positionjoinsel
|
positionsel
|
regexeqjoinsel
|
regexeqsel
|
regexnejoinsel
|
regexnesel
|
scalargtjoinsel
|
scalargtsel
|
scalarltjoinsel
|
scalarltsel
|
tsmatchjoinsel
|
tsmatchsel
|
-
|
统计信息收集函数
array_typanalyze
|
range_typanalyze
|
ts_typanalyze
|
local_rto_stat
|
|
|
排序内部功能函数
bpchar_sortsupport
|
bytea_sortsupport
|
date_sortsupport
|
numeric_sortsupport
|
timestamp_sortsupport
|
全文检索内部功能函数
dispell_init
|
dispell_lexize
|
dsimple_init
|
dsimple_lexize
|
dsnowball_init
|
dsnowball_lexize
|
dsynonym_init
|
dsynonym_lexize
|
gtsquery_compress
|
gtsquery_consistent
|
gtsquery_decompress
|
gtsquery_penalty
|
gtsquery_picksplit
|
gtsquery_same
|
gtsquery_union
|
ngram_end
|
ngram_lextype
|
ngram_start
|
pound_end
|
pound_lextype
|
pound_start
|
prsd_end
|
prsd_headline
|
prsd_lextype
|
prsd_start
|
thesaurus_init
|
thesaurus_lexize
|
zhprs_end
|
zhprs_getlexeme
|
zhprs_lextype
|
zhprs_start
|
-
|
-
|
-
|
-
|
内部类型处理函数
abstimerecv
|
euc_jis_2004_to_utf8
|
int2recv
|
line_recv
|
oidvectorrecv_extend
|
tidrecv
|
utf8_to_koi8u
|
anyarray_recv
|
euc_jp_to_mic
|
int2vectorrecv
|
lseg_recv
|
path_recv
|
time_recv
|
utf8_to_shift_jis_2004
|
array_recv
|
euc_jp_to_sjis
|
int4recv
|
macaddr_recv
|
pg_node_tree_recv
|
time_transform
|
utf8_to_sjis
|
ascii_to_mic
|
euc_jp_to_utf8
|
int8recv
|
mic_to_ascii
|
point_recv
|
timestamp_recv
|
utf8_to_uhc
|
ascii_to_utf8
|
euc_kr_to_mic
|
internal_out
|
mic_to_big5
|
poly_recv
|
timestamp_transform
|
utf8_to_win
|
big5_to_euc_tw
|
euc_kr_to_utf8
|
interval_recv
|
mic_to_euc_cn
|
pound_nexttoken
|
timestamptz_recv
|
uuid_recv
|
big5_to_mic
|
euc_tw_to_big5
|
interval_transform
|
mic_to_euc_jp
|
prsd_nexttoken
|
timetz_recv
|
varbit_recv
|
big5_to_utf8
|
euc_tw_to_mic
|
iso_to_koi8r
|
mic_to_euc_kr
|
range_recv
|
tintervalrecv
|
varbit_transform
|
bit_recv
|
euc_tw_to_utf8
|
iso_to_mic
|
mic_to_euc_tw
|
rawrecv
|
tsqueryrecv
|
varchar_transform
|
boolrecv
|
float4recv
|
iso_to_win1251
|
mic_to_iso
|
record_recv
|
tsvectorrecv
|
varcharrecv
|
box_recv
|
float8recv
|
iso_to_win866
|
mic_to_koi8r
|
regclassrecv
|
txid_snapshot_recv
|
void_recv
|
bpcharrecv
|
gb18030_to_utf8
|
iso8859_1_to_utf8
|
mic_to_latin1
|
regconfigrecv
|
uhc_to_utf8
|
win_to_utf8
|
btoidsortsupport
|
gbk_to_utf8
|
iso8859_to_utf8
|
mic_to_latin2
|
regdictionaryrecv
|
unknownrecv
|
win1250_to_latin2
|
bytearecv
|
gin_extract_tsvector
|
johab_to_utf8
|
mic_to_latin3
|
regoperatorrecv
|
utf8_to_ascii
|
win1250_to_mic
|
byteawithoutorderwithequalcolrecv
|
gtsvector_compress
|
json_recv
|
mic_to_latin4
|
regoperrecv
|
utf8_to_big5
|
win1251_to_iso
|
cash_recv
|
gtsvector_consistent
|
koi8r_to_iso
|
mic_to_sjis
|
regprocedurerecv
|
utf8_to_euc_cn
|
win1251_to_koi8r
|
charrecv
|
gtsvector_decompress
|
koi8r_to_mic
|
mic_to_win1250
|
regprocrecv
|
utf8_to_euc_jis_2004
|
win1251_to_mic
|
cidr_recv
|
gtsvector_penalty
|
koi8r_to_utf8
|
mic_to_win1251
|
regtyperecv
|
utf8_to_euc_jp
|
win1251_to_win866
|
cidrecv
|
gtsvector_picksplit
|
koi8r_to_win1251
|
mic_to_win866
|
reltimerecv
|
utf8_to_euc_kr
|
win866_to_iso
|
circle_recv
|
gtsvector_same
|
koi8r_to_win866
|
namerecv
|
shift_jis_2004_to_euc_jis_2004
|
utf8_to_euc_tw
|
win866_to_koi8r
|
cstring_recv
|
gtsvector_union
|
koi8u_to_utf8
|
ngram_nexttoken
|
shift_jis_2004_to_utf8
|
utf8_to_gb18030
|
win866_to_mic
|
date_recv
|
hll_recv
|
latin1_to_mic
|
numeric_recv
|
sjis_to_euc_jp
|
utf8_to_gbk
|
win866_to_win1251
|
domain_recv
|
hll_trans_recv
|
latin2_to_mic
|
numeric_transform
|
sjis_to_mic
|
utf8_to_iso8859
|
xidrecv
|
euc_cn_to_mic
|
hstore_recv
|
latin2_to_win1250
|
nvarchar2recv
|
sjis_to_utf8
|
utf8_to_iso8859_1
|
xidrecv4
|
euc_cn_to_utf8
|
inet_recv
|
latin3_to_mic
|
oidrecv
|
smalldatetime_recv
|
utf8_to_johab
|
xml_recv
|
euc_jis_2004_to_shift_jis_2004
|
int1recv
|
latin4_to_mic
|
oidvectorrecv
|
textrecv
|
utf8_to_koi8r
|
cstore_tid_out
|
i16toi1
|
int16
|
int16_bool
|
int16eq
|
int16div
|
int16ge
|
int16gt
|
int16in
|
int16le
|
int16lt
|
int16mi
|
int16mul
|
int16ne
|
int16out
|
int16pl
|
int16recv
|
int16send
|
numeric_bool
|
int2vectorin_extend
|
int2vectorout_extend
|
int2vectorrecv_extend
|
int2vectorsend_extend
|
jsonb_in
|
jsonb_out
|
jsonb_recv
|
jsonb_send
|
complex_array_in
|
bool_int1
|
bool_int2
|
bool_int8
|
bpchar_float4
|
bpchar_float8
|
bpchar_int4
|
bpchar_int8
|
bpchar_numeric
|
bpchar_timestamp
|
f4toi1
|
f8toi1
|
float4_bpchar
|
float4_text
|
float4_varchar
|
float8_bpchar
|
float8_text
|
float8_varchar
|
i1tof4
|
i1tof8
|
i1toi2
|
i1toi4
|
i1toi8
|
i2toi1
|
i4toi1
|
i8toi1
|
int1_avg_accum
|
int1_bool
|
int1_bpchar
|
int1_numeric
|
int1_nvarchar2
|
int1_text
|
int1_varchar
|
int1abs
|
int1and
|
int1cmp
|
int1div
|
int1eq
|
int1ge
|
int1gt
|
int1in
|
int1inc
|
int1larger
|
int1le
|
int1lt
|
int1mi
|
int1mod
|
int1mul
|
int1ne
|
int1not
|
int1or
|
int1out
|
int1pl
|
int1shl
|
int1shr
|
int1smaller
|
int1um
|
int1up
|
int1xor
|
int2_bool
|
int2_bpchar
|
int2_text
|
int2_varchar
|
int4_bpchar
|
int4_text
|
int4_varchar
|
int8_bool
|
int8_bpchar
|
int8_text
|
int8_varchar
|
job_submit
|
numeric_bpchar
|
numeric_int1
|
numeric_text
|
numeric_varchar
|
nvarchar2in
|
nvarchar2out
|
nvarchar2send
|
oidvectorin_extend
|
oidvectorout_extend
|
oidvectorsend_extend
|
rawcmp
|
raweq
|
rawge
|
rawgt
|
rawin
|
rawle
|
rawlike
|
rawlt
|
rawne
|
rawnlike
|
rawout
|
rawsend
|
text_float4
|
text_float8
|
text_int1
|
text_int2
|
text_int4
|
text_int8
|
text_numeric
|
timestamp_text
|
timestamp_varchar
|
varchar_float4
|
varchar_float8
|
varchar_int4
|
varchar_int8
|
varchar_numeric
|
xidout4
|
xidsend4
|
calculate_quantile_of
|
calculate_value_at
|
large_seq_rollback_ntree
|
large_seq_upgrade_ntree
|
-
|
聚合操作内部函数
array_agg_finalfn
|
array_agg_transfn
|
bytea_string_agg_finalfn
|
bytea_string_agg_transfn
|
date_list_agg_noarg2_transfn
|
date_list_agg_transfn
|
float4_list_agg_noarg2_transfn
|
float4_list_agg_transfn
|
float8_list_agg_noarg2_transfn
|
float8_list_agg_transfn
|
int2_list_agg_noarg2_transfn
|
int2_list_agg_transfn
|
int4_list_agg_noarg2_transfn
|
int4_list_agg_transfn
|
int8_list_agg_noarg2_transfn
|
int8_list_agg_transfn
|
interval_list_agg_noarg2_transfn
|
interval_list_agg_transfn
|
list_agg_finalfn
|
list_agg_noarg2_transfn
|
list_agg_transfn
|
median_float8_finalfn
|
median_interval_finalfn
|
median_transfn
|
mode_final
|
numeric_list_agg_noarg2_transfn
|
numeric_list_agg_transfn
|
ordered_set_transition
|
percentile_cont_float8_final
|
percentile_cont_interval_final
|
string_agg_finalfn
|
string_agg_transfn
|
timestamp_list_agg_noarg2_transfn
|
timestamp_list_agg_transfn
|
timestamptz_list_agg_noarg2_transfn
|
timestamptz_list_agg_transfn
|
checksumtext_agg_transfn
|
-
|
-
|
-
|
-
|
-
|
json_agg_finalfn
|
json_agg_transfn
|
json_object_agg_finalfn
|
json_object_agg_transfn
|
-
|
-
|
-
|
哈希内部功能函数
hashbeginscan
|
hashbuild
|
hashbuildempty
|
hashbulkdelete
|
hashcostestimate
|
hashendscan
|
hashgetbitmap
|
hashgettuple
|
hashinsert
|
hashmarkpos
|
hashmerge
|
hashrescan
|
hashrestrpos
|
hashvacuumcleanup
|
hashvarlena
|
-
|
-
|
-
|
-
|
-
|
-
|
Btree索引内部功能函数
cbtreebuild
|
cbtreecanreturn
|
cbtreecostestimate
|
cbtreegetbitmap
|
cbtreegettuple
|
btbeginscan
|
btbuild
|
btbuildempty
|
btbulkdelete
|
btcanreturn
|
btcostestimate
|
btendscan
|
btfloat4sortsupport
|
btfloat8sortsupport
|
btgetbitmap
|
btgettuple
|
btinsert
|
btint2sortsupport
|
btint4sortsupport
|
btint8sortsupport
|
btmarkpos
|
btmerge
|
btnamesortsupport
|
btrescan
|
btrestrpos
|
bttextsortsupport
|
btvacuumcleanup
|
cbtreeoptions
|
GiST索引内部功能函数
gist_box_compress
|
gist_box_consistent
|
gist_box_decompress
|
gist_box_penalty
|
gist_box_picksplit
|
gist_box_same
|
gist_box_union
|
gist_circle_compress
|
gist_circle_consistent
|
gist_point_compress
|
gist_point_consistent
|
gist_point_distance
|
gist_poly_compress
|
gist_poly_consistent
|
gistbeginscan
|
gistbuild
|
gistbuildempty
|
gistbulkdelete
|
gistcostestimate
|
gistendscan
|
gistgetbitmap
|
gistinsert
|
gistmarkpos
|
gistmerge
|
gistrescan
|
gistrestrpos
|
gistvacuumcleanup
|
range_gist_compress
|
range_gist_decompress
|
range_gist_penalty
|
range_gist_picksplit
|
range_gist_same
|
range_gist_union
|
spg_kd_choose
|
spg_kd_config
|
spg_kd_picksplit
|
spg_quad_choose
|
spg_quad_config
|
spg_quad_inner_consistent
|
spg_quad_leaf_consistent
|
spg_quad_picksplit
|
spg_text_choose
|
spg_text_inner_consistent
|
spg_text_leaf_consistent
|
spg_text_picksplit
|
spgbeginscan
|
spgbuild
|
spgbuildempty
|
spgbulkdelete
|
spgcostestimate
|
spgendscan
|
spggetbitmap
|
spggettuple
|
spginsert
|
spgmarkpos
|
spgmerge
|
spgrestrpos
|
spgvacuumcleanup
|
-
|
-
|
-
|
-
|
-
|
Gin索引内部功能函数
gin_cmp_prefix
|
gin_extract_tsquery
|
gin_tsquery_consistent
|
gin_tsquery_triconsistent
|
ginarrayconsistent
|
ginarrayextract
|
ginarraytriconsistent
|
ginbeginscan
|
ginbuild
|
ginbuildempty
|
ginbulkdelete
|
gincostestimate
|
ginendscan
|
gingetbitmap
|
gininsert
|
ginmarkpos
|
ginmerge
|
ginqueryarrayextract
|
ginrescan
|
ginrestrpos
|
ginvacuumcleanup
|
cginbuild
|
cgingetbitmap
|
-
|
-
|
-
|
-
|
-
|
gin_compare_jsonb
|
gin_consistent_jsonb
|
gin_consistent_jsonb_hash
|
gin_extract_jsonb
gin_extract_jsonb_hash
|
cginbuild
|
gin_extract_jsonb_query
|
gin_triconsistent_jsonb
|
Psort索引内部函数
psortbuild
|
psortcanreturn
|
psortcostestimate
|
psortgetbitmap
|
psortgettuple
|
Ubtree索引内部函数
ubtbeginscan
|
ubtbuild
|
ubtbuildempty
|
ubtbulkdelete
|
ubtcanreturn
|
ubtcostestimate
|
ubtendscan
|
ubtgetbitmap
|
ubtgettuple
|
ubtinsert
|
ubtmarkpos
|
ubtmerge
|
ubtoptions
|
ubtrescan
|
ubtrestrpos
|
ubtvacuumcleanup
|
|
|
|
|
plpgsql内部函数
plpgsql_inline_handler
集合相关内部函数
array_indexby_delete
|
array_indexby_length
|
array_integer_deleteidx
|
array_integer_exists
|
array_integer_first
|
array_integer_last
|
array_integer_next
|
array_integer_prior
|
array_varchar_deleteidx
|
array_varchar_exists
|
array_varchar_first
|
array_varchar_last
|
array_varchar_next
|
array_varchar_prior
|
-
|
-
|
-
|
-
|
外表相关内部函数
dist_fdw_handler
|
roach_handler
|
streaming_fdw_handler
|
dist_fdw_validator
|
file_fdw_handler
|
file_fdw_validator
|
log_fdw_handler
|
主数据库节点远程读取备数据库节点数据页辅助函数
gs_read_block_from_remote用于读取非段页式表文件的页面。默认只有初始化用户可以查看,其余用户需要赋权后才可以使用。
pg_read_binary_file_blocks用于读取数据,非压缩表返回实际数据,压缩表返回压缩后的数据。默认只有初始化用户可以查看,其余用户需要赋权后才可以使用。
gs_read_segment_block_from_remote用于读取段页式表文件的页面。默认只有初始化用户可以查看,其余用户需要赋权后才可以使用。
主数据库节点远程读取备数据库节点数据文件辅助函数
gs_read_file_from_remote用于读取指定的文件。gs_repair_file利用gs_read_file_size_from_remote函数获取文件大小后,依赖这个函数将远端文件逐段读取。默认只有初始化用户可以查看,其余用户需要赋权后才可以使用。
gs_read_file_size_from_remote用于读取指定文件的大小。用于读取指定文件的大小,gs_repair_file函数修复文件时,要先获取远端关于这个文件的大小,用于校验本地文件缺失的文件信息,然后将缺失的文件逐个修复。默认只有初始化用户可以查看,其余用户需要赋权后才可以使用。
账本数据库函数
get_dn_hist_relhash
AI特性函数
create_snapshot
|
create_snapshot_internal
|
prepare_snapshot_internal
|
prepare_snapshot
|
manage_snapshot_internal
|
archive_snapshot
|
publish_snapshot
|
purge_snapshot_internal
|
purge_snapshot
|
sample_snapshot
|
|
|
|
|
PKG_SERVICE函数
isubmit_on_nodes
|
submit_on_nodes
|
|
|
|
|
|
其他函数
to_tsvector_for_batch
|
value_of_percentile
|
disabled_conn
|
bind_variable
|
job_update
|
job_cancel
|
job_finish
|
similar_escape
|
table_skewness (不可用)
|
timetz_text
|
time_text
|
reltime_text
|
abstime_text
|
_pg_keysequal
|
analyze_query
(不可用)
|
analyze_workload (不可用)
|
ssign_table_type
|
gs_comm_proxy_thread_status
|
gs_txid_oldestxmin
|
pg_cancel_session
|
pg_stat_segment_space_info
|
remote_segment_space_info
|
set_cost_params
|
set_weight_params
|
start_collect_workload
|
tdigest_in
|
tdigest_merge
|
tdigest_merge_to_one
|
tdigest_mergep
|
tdigest_out
|
pg_get_delta_info
|
disable_conn
|
-
|
-
|
-
|