内部函数
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 | remote_rto_stat | gs_plan_trace_delete | gs_plan_trace_watch_sqlid |
gs_plan_trace_show_sqlids | 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 | - |
numeric_bool | int2vectorin_extend | int2vectorout_extend | int2vectorrecv_extend | int2vectorsend_extend | int8_accum | large_seq_rollback_ntree |
large_seq_upgrade_ntree | int16eq | int16ge | int16gt | int16in | int16le | int16lt |
int16mi | int16mul | int16ne | int16out | int16pl | int16recv | int16send |
int16_bool | i16toi1 | anyset_in | 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 | 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_transfn | json_agg_finalfn | json_object_agg_transfn | json_object_agg_finalfn |
哈希内部功能函数
hashbeginscan | hashbuild | hashbuildempty | hashbulkdelete | hashcostestimate | hashendscan | hashgetbitmap |
hashgettuple | hashinsert | hashmarkpos | hashmerge | hashrescan | hashrestrpos | hashvacuumcleanup |
hashvarlena | jsonb_hash | - | - | - | - | - |
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 | - | - |
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 | - | - | - | - | - | - |
外表相关内部函数
dist_fdw_handler | roach_handler | streaming_fdw_handler | dist_fdw_validator | file_fdw_handler | file_fdw_validator | log_fdw_handler |
gc_fdw_handler | gc_fdw_validator | dblink_fdw_handler | dblink_fdw_validator | - | - | - |
数据倾斜优化相关内部函数
distributed_count | - | - | - | - | - | - |
表统计信息相关内部函数
pgxc_get_stat_dirty_tables | pgxc_stat_dirty_tables | get_global_stat_all_tables | get_summary_stat_all_tables | - | - | - |
- | - | - | - | - | - | - |
远程读取数据函数
远程读取文件函数
以备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 | - | - | - | - | - | - |
视图相关引用函数
adm_hist_sqlstat_func | adm_hist_sqlstat_idlog_func | adm_hist_sqltext_func | - | - | - | - |
gs_txn_snapshot系统表维护函数
gs_insert_delete_txn_snapshot用于分布式GTM-Lite模式下维护全局各节点gs_txn_snapshot系统表,只有系统管理员用户才能调用。
xmltype类型相关函数
isschemavalid(不可用) | - | - | - | - | - | - |
应用无损透明特性内部函数
gs_ltxid | - | - | - | - | - | - |

