文档中心
MogDBMogDB StackUqbar
生态工具
v3.0
文档目录
文档:v3.0
其他版本:

内部函数

MogDB中下列函数使用了内部数据类型,用户无法直接调用,在此章节列出。

  • 选择率计算函数

    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_jsonbgin_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 session_context 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 - - -
Copyright © 2009-2022 www.enmotech.com All rights reserved.