内部函数
GaussDB中下列函数使用了内部数据类型，用户无法直接调用，在此章节列出。
选择率计算函数
|
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 |
standby_statement_history_internal |
- |
排序内部功能函数
|
bpchar_sortsupport |
bytea_sortsupport |
date_sortsupport |
numeric_sortsupport |
timestamp_sortsupport |
内部类型处理函数
|
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 |
- |
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 |
- |
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 |
- |
|
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 |
tdigest_in |
tdigest_merge |
tdigest_merge_to_one |
tdigest_mergep |
tdigest_out |
- |
|
anyset_out |
btint2setcmp |
btint4setcmp |
btint8setcmp |
btsetcmp |
btsetint2cmp |
btsetint4cmp |
|
btsetint8cmp |
btsetsortsupport |
float4 |
float8 |
hashsetint |
hashsettext |
int2 |
|
int2seteq |
int2setge |
int2setgt |
int2setle |
int2setlt |
int2setne |
int4 |
|
int4seteq |
int4setge |
int4setgt |
int4setle |
int4setlt |
int4setne |
int8 |
|
int8seteq |
int8setge |
int8setgt |
int8setle |
int8setlt |
int8setne |
set |
|
set_in |
set_out |
set_recv |
set_send |
seteq |
setge |
setgt |
|
setint2eq |
setint2ge |
setint2gt |
setint2le |
setint2lt |
setint2ne |
setint4eq |
|
setint4ge |
setint4gt |
setint4le |
setint4lt |
setint4ne |
setint8eq |
setint8ge |
|
setint8gt |
setint8le |
setint8lt |
setint8ne |
setle |
setlt |
setne |
|
settexteq |
settextge |
settextgt |
settextle |
settextlt |
settextne |
settobpchar |
|
settonumber |
settonvarchar2 |
settotext |
settovarchar |
textseteq |
textsetge |
textsetgt |
|
textsetle |
textsetlt |
textsetne |
gb18030_2022_to_utf8 |
utf8_to_gb18030_2022 |
array_to_nesttable |
array_to_indexby_int_table |
|
nesttable_to_array |
indexbytableint_to_array |
array_to_nesttable |
array_to_indexby_int_table |
zhs16gbk_to_utf8 |
utf8_to_zhs16gbk |
zhs16gbk_to_gb18030 |
|
gb18030_to_zhs16gbk |
zhs16gbk_to_gb18030_2022 |
gb18030_2022_to_zhs16gbk |
- |
- |
- |
- |
聚合操作内部函数
|
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 |
- |
- |
- |
- |
- |
哈希内部功能函数
|
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 |
Psort索引内部函数
|
psortbuild |
psortcanreturn |
psortcostestimate |
psortgetbitmap |
psortgettuple |
Ugin索引内部函数
|
ugininsert |
uginbeginscan |
ugingetbitmap |
uginrescan |
uginendscan |
|
uginbuild |
uginbuildempty |
uginbulkdelete |
uginvacuumcleanup |
ugincostestimate |
|
uginoptions |
ugin_extract_value_trgm |
ugin_extract_query_trgm |
ugin_trgm_consistent |
ugin_trgm_triconsistent |
Ubtree索引内部函数
|
ubtbeginscan |
ubtbuild |
ubtbuildempty |
ubtbulkdelete |
ubtcanreturn |
|
ubtcostestimate |
ubtendscan |
ubtgetbitmap |
ubtgettuple |
ubtinsert |
|
ubtmarkpos |
ubtmerge |
ubtoptions |
ubtrescan |
ubtrestrpos |
|
ubtvacuumcleanup |
- |
- |
- |
- |
GsIVFFLAT索引内部函数
|
ivfflatbeginscan |
ivfflatbuild |
ivfflatbuildempty |
ivfflatbulkdelete |
ivfflatinsert |
|
ivfflatcostestimate |
ivfflatendscan |
ivfflatoptions |
ivfflatgettuple |
ivfflatvacuumcleanup |
|
ivfflatrescan |
- |
- |
- |
- |
GsDiskANN索引内部函数
|
diskannbeginscan |
diskannbuild |
diskannbuildempty |
diskannbulkdelete |
diskanninsert |
|
diskanncostestimate |
diskannendscan |
diskannoptions |
diskanngettuple |
diskannvacuumcleanup |
|
diskannrescan |
- |
- |
- |
- |
BM25索引内部函数
|
gs_bm25beginscan |
gs_bm25build |
gs_bm25buildempty |
gs_bm25bulkdelete |
gs_bm25insert |
|
gs_bm25costestimate |
gs_bm25endscan |
gs_bm25options |
gs_bm25gettuple |
gs_bm25vacuumcleanup |
|
gs_bm25rescan |
- |
- |
- |
- |
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 |
|
dblink_fdw_handler |
dblink_fdw_validator |
- |
- |
- |
- |
- |
主DN远程读取备DN数据页辅助函数
gs_read_block_from_remote用于读取非段页式表文件的页面。默认只有初始化用户可以查看，其余用户需要赋权后才可以使用。
gs_read_segment_block_from_remote用于读取段页式表文件的页面。默认只有初始化用户可以查看，其余用户需要赋权后才可以使用。
主DN远程读取备DN数据文件辅助函数
gs_read_file_from_remote用于读取指定的文件。gs_repair_file利用gs_read_file_size_from_remote函数获取文件大小后，依赖这个函数将远端文件逐段读取。默认只有初始化用户可以查看，其余用户需要赋权后才可以使用。
gs_read_file_size_from_remote用于读取指定文件的大小。gs_repair_file函数修复文件时，要先获取远端关于这个文件的大小，用于校验本地文件缺失的文件信息，然后将缺失的文件逐个修复。默认只有初始化用户可以查看，其余用户需要赋权后才可以使用。
以备DN实例增量重建其他备或级联备DN实例辅助函数
gs_standby_incremental_filemap_create用于创建备DN增量重建临时filemap文件，用于存储当次增量重建需传输的数据路径与大小。只有初始化用户且application为gs_rewind时可以调用。
gs_standby_incremental_filemap_insert用于向指定临时filemap文件中插入文件信息，指定文件的路径、传输起始点、单次传输数据长度和rebuild标志位。只有初始化用户且application为gs_rewind时可以调用。
gs_standby_incremental_filemap_execute用于获取指定临时filemap文件中存储的文件信息并删除指定filemap，用于备DN增量重建的数据传输。只有初始化用户且application为gs_rewind时可以调用。
账本数据库函数
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 |
disable_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 |
gs_ltxid |
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 |
- |
- |
- |
- |
- |
视图相关引用函数
adm_hisadm_hist_sqltext_funct_sqlstat_func
adm_hist_sqlstat_idlog_func
adm_hist_sqltext_func
gs_txn_snapshot系统表维护函数
gs_insert_delete_txn_snapshot用于GTM-Lite模式下维护全局各节点gs_txn_snapshot系统表，只有系统管理员用户才能调用，当前版本调用该函数将返回f，无实际操作。
xmltype类型相关函数
isschemavalid
