更新时间:2024-05-07 GMT+08:00

内部函数

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

    -

    -

  • 排序内部功能函数

    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

  • 聚合操作内部函数

    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

  • 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

    dblink_fdw_handler

    dblink_fdw_validator

    -

    -

    -

    -

    -

  • 主DN远程读取备DN数据页辅助函数

    gs_read_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时可以调用。

  • 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

    -

    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_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系统表,只有系统管理员用户才能调用,当前版本调用该函数将返回f,无实际操作。

  • xmltype类型相关函数

    isschemavalid