# 其他系统函数 其他系统函数包含两类，兼容PostgreSQL的函数和实现内部功能的函数。这些函数不推荐使用，若需使用，请联系华为技术支持工程师。 #### 兼容PostgreSQL的函数和操作符 GaussDB的内建函数和操作符兼容PostgreSQL。其中部分函数为系统内部调用函数（如send、recv等）不支持用户使用；其他函数不推荐使用，若需使用，请联系华为技术支持工程师。 | _pg_char_max_length | _pg_char_octet_length | _pg_datetime_precision | _pg_expandarray | _pg_index_position | _pg_interval_type | _pg_numeric_precision | |---|---|---|---|---|---|---| | _pg_numeric_precision_radix | _pg_numeric_scale | _pg_truetypid | _pg_truetypmod | abbrev | abs | abstime | | abstimeeq | abstimege | abstimegt | abstimein | abstimele | abstimelt | abstimene | | abstimeout | abstimerecv | abstimesend | aclcontains | acldefault | aclexplode | aclinsert | | aclitemeq | aclitemin | aclitemout | aclremove | acos | age | akeys | | any_in | any_out | anyarray_in | anyarray_out | anyarray_recv | anyarray_send | anyelement_in | | anyelement_out | anyenum_in | anyenum_out | anynonarray_in | anynonarray_out | anyrange_in | anyrange_out | | anytextcat | area | areajoinsel | areasel | array_agg | array_agg_finalfn | array_agg_transfn | | array_append | array_cat | array_dims | array_eq | array_fill | array_ge | array_gt | | array_in | array_larger | array_le | array_length | array_lower | array_lt | array_ndims | | array_ne | array_out | array_prepend | array_recv | array_send | array_smaller | array_to_json | | array_to_string | array_typanalyze | array_upper | arraycontained | arraycontains | arraycontjoinsel | arraycontsel | | arrayoverlap | ascii | asin | atan | atan2 | avals | avg | | big5_to_euc_tw | big5_to_mic | big5_to_utf8 | bit | bit_and | bit_in | bit_length | | bit_or | bit_out | bit_recv | bit_send | bitand | bitcat | bitcmp | | biteq | bitge | bitgt | bitle | bitlt | bitne | bitnot | | bitor | bitshiftleft | bitshiftright | bittypmodin | bittypmodout | bitxor | bool | | bool_and | bool_or | booland_statefunc | booleq | boolge | boolgt | boolin | | boolle | boollt | boolne | boolor_statefunc | boolout | boolrecv | boolsend | | box | box_above | box_above_eq | box_add | box_below | box_below_eq | box_center | | box_contain | box_contain_pt | box_contained | box_distance | box_div | box_eq | box_ge | | box_gt | box_in | box_intersect | box_le | box_left | box_lt | box_mul | | box_out | box_overabove | box_overbelow | box_overlap | box_overleft | box_overright | box_recv | | box_right | box_same | box_send | box_sub | bpchar | bpchar_larger | bpchar_pattern_ge | | bpchar_pattern_gt | bpchar_pattern_le | bpchar_pattern_lt | bpchar_smaller | bpchar_sortsupport | bpcharcmp | bpchareq | | bpcharge | bpchargt | bpchariclike | bpcharicnlike | bpcharicregexeq | bpcharicregexne | bpcharin | | bpcharle | bpcharlike | bpcharlt | bpcharne | bpcharnlike | bpcharout | bpcharrecv | | bpcharregexeq | bpcharregexne | bpcharsend | bpchartypmodin | bpchartypmodout | broadcast | btabstimecmp | | btarraycmp | btbeginscan | btboolcmp | btbpchar_pattern_cmp | btbuild | btbuildempty | btbulkdelete | | btcanreturn | btcharcmp | btcostestimate | btendscan | btfloat48cmp | btfloat4cmp | btfloat4sortsupport | | btfloat84cmp | btfloat8cmp | btfloat8sortsupport | btgetbitmap | btgettuple | btinsert | btint24cmp | | btint28cmp | btint2cmp | btint2sortsupport | btint42cmp | btint48cmp | btint4cmp | btint4sortsupport | | btint82cmp | btint84cmp | btint8cmp | btint8sortsupport | btmarkpos | btnamecmp | btnamesortsupport | | btoidcmp | btoidsortsupport | btoidvectorcmp | btoptions | btrecordcmp | btreltimecmp | btrescan | | btrestrpos | btrim | bttext_pattern_cmp | bttextcmp | bttextsortsupport | bttidcmp | bttintervalcmp | | btvacuumcleanup | bytea_sortsupport | bytea_string_agg_finalfn | bytea_string_agg_transfn | byteacat | byteacmp | byteaeq | | byteage | byteagt | byteain | byteale | bytealike | bytealt | byteane | | byteanlike | byteaout | bytearecv | byteasend | cash_cmp | cash_div_cash | cash_div_flt4 | | cash_div_flt8 | cash_div_int2 | cash_div_int4 | cash_div_int8 | cash_eq | cash_ge | cash_gt | | cash_in | cash_le | cash_lt | cash_mi | cash_mul_flt4 | cash_mul_flt8 | cash_mul_int2 | | cash_mul_int4 | cash_mul_int8 | cash_ne | cash_out | cash_pl | cash_recv | cash_send | | cashlarger | cashsmaller | cbrt | ceil | ceiling | center | char | | char_length | character_length | chareq | charge | chargt | charin | charle | | charlt | charne | charout | charrecv | charsend | chr | cideq | | cidin | cidout | cidr | cidr_in | cidr_out | cidr_recv | cidr_send | | cidrecv | cidsend | circle | circle_above | circle_add_pt | circle_below | circle_center | | circle_contain | circle_contain_pt | circle_contained | circle_distance | circle_div_pt | circle_eq | circle_ge | | circle_gt | circle_in | circle_le | circle_left | circle_lt | circle_mul_pt | circle_ne | | circle_out | circle_overabove | circle_overbelow | circle_overlap | circle_overleft | circle_overright | circle_recv | | circle_right | circle_same | circle_send | circle_sub_pt | clock_timestamp | close_lb | close_ls | | close_lseg | close_pb | close_pl | close_ps | close_sb | close_sl | col_description | | concat | concat_ws | contjoinsel | contsel | convert | convert_from | convert_to | | corr | cos | cot | count | covar_pop | covar_samp | cstring_in | | cstring_out | cstring_recv | cstring_send | cume_dist | current_database | current_query | current_schema | | - | current_setting | current_user | currtid | currtid2 | currval | - | | - | - | - | - | date | date_cmp | date_cmp_timestamp | | date_cmp_timestamptz | date_eq | date_eq_timestamp | date_eq_timestamptz | date_ge | date_ge_timestamp | date_ge_timestamptz | | date_gt | date_gt_timestamp | date_gt_timestamptz | date_in | date_larger | date_le | date_le_timestamp | | date_le_timestamptz | date_lt | date_lt_timestamp | date_lt_timestamptz | date_mi | date_mi_interval | date_mii | | date_ne | date_ne_timestamp | date_ne_timestamptz | date_out | date_pl_interval | date_pli | date_recv | | date_send | date_smaller | date_sortsupport | daterange_canonical | daterange_subdiff | datetime_pl | datetimetz_pl | | dcbrt | decode | defined | degrees | delete | dense_rank | dexp | | diagonal | diameter | dispell_init | dispell_lexize | dist_cpoly | dist_lb | dist_pb | | dist_pc | dist_pl | dist_ppath | dist_ps | dist_sb | dist_sl | div | | dlog1 | dlog10 | domain_in | domain_recv | dpow | dround | dsimple_init | | dsimple_lexize | dsnowball_init | dsnowball_lexize | dsqrt | dsynonym_init | dsynonym_lexize | dtrunc | | each | enum_ne | enum_out | enum_range | enum_recv | enum_send | enum_smaller | | eqjoinsel | eqsel | euc_cn_to_mic | euc_cn_to_utf8 | euc_jis_2004_to_shift_jis_2004 | euc_jis_2004_to_utf8 | euc_jp_to_mic | | euc_jp_to_sjis | euc_jp_to_utf8 | euc_kr_to_mic | euc_kr_to_utf8 | euc_tw_to_big5 | euc_tw_to_mic | euc_tw_to_utf8 | | every | exist | exists_all | exists_any | exp | factorial | family | | fdw_handler_in | fdw_handler_out | fetchval | first_value | float4 | float4_accum | float48div | | float48eq | float48ge | float48gt | float48le | float48lt | float48mi | float48mul | | float48ne | float48pl | float4abs | float4div | float4eq | float4ge | float4gt | | float4in | float4larger | float4le | float4lt | float4mi | float4mul | float4ne | | float4out | float4pl | float4recv | float4send | float4smaller | float4um | float4up | | float8 | float8_accum | float8_avg | float8_collect | float8_corr | float8_covar_pop | float8_covar_samp | | float8_regr_accum | float8_regr_avgx | float8_regr_avgy | float8_regr_collect | float8_regr_intercept | float8_regr_r2 | float8_regr_slope | | float8_regr_sxx | float8_regr_sxy | float8_regr_syy | float8_stddev_pop | float8_stddev_samp | float8_var_pop | float8_var_samp | | float84div | float84eq | float84ge | float84gt | float84le | float84lt | float84mi | | float84mul | float84ne | float84pl | float8abs | float8div | float8eq | float8ge | | float8gt | float8in | float8larger | float8le | float8lt | float8mi | float8mul | | float8ne | float8out | float8pl | float8recv | float8send | float8smaller | float8um | | float8up | floor | flt4_mul_cash | flt8_mul_cash | fmgr_c_validator | fmgr_internal_validator | fmgr_sql_validator | | format | format_type | gb18030_to_utf8 | gbk_to_utf8 | generate_series | generate_subscripts | get_bit | | get_byte | get_current_ts_config | - | - | - | - | - | | gtsquery_compress | gtsquery_consistent | gtsquery_decompress | gtsquery_penalty | gtsquery_picksplit | gtsquery_same | gtsquery_union | | gtsvector_compress | gtsvector_consistent | gtsvector_decompress | gtsvector_penalty | gtsvector_picksplit | gtsvector_same | gtsvector_union | | gtsvectorin | gtsvectorout | has_tablespace_privilege | has_type_privilege | hash_aclitem | hashbeginscan | hashbuild | | hashbuildempty | hashbulkdelete | hashcostestimate | hashendscan | hashgetbitmap | hashgettuple | hashinsert | | hashint2vector | hashint4 | hashint8 | hashmacaddr | hashmarkpos | hashname | hashoid | | hashoidvector | hashoptions | hashrescan | hashrestrpos | hashtext | hashvacuumcleanup | hashvarlena | | host | hostmask | iclikejoinsel | iclikesel | icnlikejoinsel | icnlikesel | icregexeqjoinsel | | icregexeqsel | icregexnejoinsel | icregexnesel | inet_client_addr | inet_client_port | inet_in | inet_out | | inet_recv | inet_send | inet_server_addr | inet_server_port | inetand | inetmi | inetmi_int8 | | inetnot | inetor | inetpl | initcap | int2_accum | int2_avg_accum | int2_mul_cash | | int2_sum | int24div | int24eq | int24ge | int24gt | int24le | int24lt | | int24mi | int24mul | int24ne | int24pl | int28div | int28eq | int28ge | | int28gt | int28le | int28lt | int28mi | int28mul | int28ne | int28pl | | int2abs | int2and | int2div | int2eq | int2ge | int2gt | int2in | | int2larger | int2le | int2lt | int2mi | int2mod | int2mul | int2ne | | int2not | int2or | int2out | int2pl | int2recv | int2send | int2shl | | int2shr | int2smaller | int2um | int2up | int2vectoreq | int2vectorin | int2vectorout | | int2vectorrecv | int2vectorsend | int2xor | int4_accum | int4_avg_accum | int4_mul_cash | int4_sum | | int42div | int42eq | int42ge | int42gt | int42le | int42lt | int42mi | | int42mul | int42ne | int42pl | int48div | int48eq | int48ge | int48gt | | int48le | int48lt | int48mi | int48mul | int48ne | int48pl | int4abs | | int4and | int4div | int4eq | int4ge | int4gt | int4in | int4inc | | int4larger | int4le | int4lt | int4mi | int4mod | int4mul | int4ne | | int4not | int4or | int4out | int4pl | int4range | int4range_canonical | int4range_subdiff | | int4recv | int4send | int4shl | int4shr | int4smaller | int4um | int4up | | int4xor | int8 | int8_avg | int8_avg_accum | int8_avg_collect | int8_mul_cash | int8_sum | | int8_sum_to_int8 | int8_accum | int82div | int82eq | int82ge | int82gt | int82le | | int82lt | int82mi | int82mul | int82ne | int82pl | int84div | int84eq | | int84ge | int84gt | int84le | int84lt | int84mi | int84mul | int84ne | | int84pl | int8abs | int8and | int8div | int8eq | int8ge | int8gt | | int8in | int8inc | int8inc_any | int8inc_float8_float8 | int8larger | int8le | int8lt | | int8mi | int8mod | int8mul | int8ne | int8not | int8or | int8out | | int8pl | int8pl_inet | int8range | int8range_canonical | int8range_subdiff | int8recv | int8send | | int8shl | int8shr | int8smaller | int8um | int8up | int8xor | integer_pl_date | | inter_lb | inter_sb | inter_sl | internal_in | internal_out | interval | interval_accum | | interval_avg | interval_cmp | interval_collect | interval_div | interval_eq | interval_ge | interval_gt | | interval_hash | interval_in | interval_larger | interval_le | interval_lt | interval_mi | interval_mul | | interval_ne | interval_out | interval_pl | interval_pl_date | interval_pl_time | interval_pl_timestamp | interval_pl_timestamptz | | interval_pl_timetz | interval_recv | interval_send | interval_smaller | interval_transform | interval_um | intervaltypmodin | | intervaltypmodout | intinterval | isexists | ishorizontal | iso_to_koi8r | iso_to_mic | iso_to_win1251 | | iso_to_win866 | iso8859_1_to_utf8 | iso8859_to_utf8 | isparallel | isperp | isvertical | johab_to_utf8 | | jsonb_in | jsonb_out | jsonb_recv | jsonb_send | - | - | - | | json_in | json_out | json_recv | json_send | justify_days | justify_hours | justify_interval | | koi8r_to_iso | koi8r_to_mic | koi8r_to_utf8 | koi8r_to_win1251 | koi8r_to_win866 | koi8u_to_utf8 | language_handler_in | | language_handler_out | latin1_to_mic | latin2_to_mic | latin2_to_win1250 | latin3_to_mic | latin4_to_mic | like_escape | | likejoinsel | likesel | line | line_distance | line_eq | line_horizontal | line_in | | line_interpt | line_intersect | line_out | line_parallel | line_perp | line_recv | line_send | | line_vertical | ln | lo_close | lo_creat | lo_create | lo_export | lo_import | | lo_lseek | lo_open | lo_tell | lo_truncate | lo_unlink | log | loread | | lower | lower_inc | lower_inf | lowrite | lpad | lseg | lseg_center | | lseg_distance | lseg_eq | lseg_ge | lseg_gt | lseg_horizontal | lseg_in | lseg_interpt | | lseg_intersect | lseg_le | lseg_length | lseg_lt | lseg_ne | lseg_out | lseg_parallel | | lseg_perp | lseg_recv | lseg_send | lseg_vertical | ltrim | macaddr_and | macaddr_cmp | | macaddr_eq | macaddr_ge | macaddr_gt | macaddr_in | macaddr_le | macaddr_lt | macaddr_ne | | macaddr_not | macaddr_or | macaddr_out | macaddr_recv | macaddr_send | makeaclitem | masklen | | max | md5（MD5加密算法安全性低，存在安全风险，建议使用更安全的加密算法） | mic_to_big5 | mic_to_euc_cn | mic_to_euc_jp | mic_to_euc_kr | mic_to_euc_tw | | mic_to_iso | mic_to_koi8r | mic_to_latin1 | mic_to_latin2 | mic_to_latin3 | mic_to_latin4 | mic_to_sjis | | mic_to_win1250 | mic_to_win1251 | mic_to_win866 | min | mktinterval | money | mul_d_interval | | name | nameeq | namege | namegt | nameiclike | nameicnlike | nameicregexeq | | nameicregexne | namein | namele | namelike | namelt | namene | namenlike | | nameout | namerecv | nameregexeq | nameregexne | namesend | neqjoinsel | neqsel | | network_cmp | network_eq | network_ge | network_gt | network_le | network_lt | network_ne | | network_sub | network_subeq | network_sup | network_supeq | nlikejoinsel | nlikesel | numeric | | numeric_abs | numeric_accum | numeric_add | numeric_avg | numeric_avg_accum | numeric_avg_collect | numeric_cmp | | numeric_collect | numeric_div | numeric_div_trunc | numeric_eq | numeric_exp | numeric_fac | numeric_ge | | numeric_gt | numeric_in | numeric_inc | numeric_larger | numeric_le | numeric_ln | numeric_log | | numeric_lt | numeric_mod | numeric_mul | numeric_ne | numeric_out | numeric_power | numeric_recv | | numeric_send | numeric_smaller | numeric_sortsupport | numeric_sqrt | numeric_stddev_pop | numeric_stddev_samp | numeric_sub | | numeric_transform | numeric_uminus | numeric_uplus | numeric_var_pop | numeric_var_samp | numerictypmodin | numerictypmodout | | numrange_subdiff | oid | oideq | oidge | oidgt | oidin | oidlarger | | oidle | oidlt | oidne | oidout | oidrecv | oidsend | oidsmaller | | oidvectoreq | oidvectorge | oidvectorgt | oidvectorin | oidvectorle | oidvectorlt | oidvectorne | | oidvectorout | oidvectorrecv | oidvectorsend | oidvectortypes | on_pb | on_pl | on_ppath | | on_ps | on_sb | on_sl | opaque_in | opaque_out | ordered_set_transition | overlaps | | overlay | path | path_add | path_add_pt | path_center | path_contain_pt | path_distance | | path_div_pt | path_in | path_inter | path_length | path_mul_pt | path_n_eq | path_n_ge | | path_n_gt | path_n_le | path_n_lt | path_npoints | path_out | path_recv | path_send | | path_sub_pt | percentile_cont | percentile_cont_float8_final | percentile_cont_interval_final | pg_char_to_encoding | pg_cursor | pg_encoding_max_length | | pg_encoding_to_char | pg_extension_config_dump | - | - | pg_node_tree_in | pg_node_tree_out | pg_node_tree_recv | | pg_node_tree_send | pg_prepared_statement | pg_prepared_xact | - | - | pg_show_all_settings | pg_stat_get_bgwriter_stat_reset_time | | pg_stat_get_buf_fsync_backend | pg_stat_get_checkpoint_sync_time | pg_stat_get_checkpoint_write_time | pg_stat_get_db_blk_read_time | pg_stat_get_db_blk_write_time | pg_stat_get_db_conflict_all | pg_stat_get_db_conflict_bufferpin | | pg_stat_get_db_conflict_snapshot | pg_stat_get_db_conflict_startup_deadlock | pg_switch_xlog | - | pg_timezone_abbrevs | pg_timezone_names | pg_stat_get_wal_receiver | | plpgsql_call_handler | plpgsql_inline_handler | plpgsql_validator | point_above | point_add | point_below | point_distance | | point_div | point_eq | point_horiz | point_in | point_left | point_mul | point_ne | | point_out | point_recv | point_right | point_send | point_sub | point_vert | poly_above | | poly_below | poly_center | poly_contain | poly_contain_pt | poly_contained | poly_distance | poly_in | | poly_left | poly_npoints | poly_out | poly_overabove | poly_overbelow | poly_overlap | poly_overleft | | poly_overright | poly_recv | poly_right | poly_same | poly_send | polygon | position | | positionjoinsel | positionsel | postgresql_fdw_validator | pow | power | prsd_end | prsd_headline | | prsd_lextype | prsd_nexttoken | prsd_start | pt_contained_circle | pt_contained_poly | - | - | | - | quote_ident | quote_literal | quote_nullable | radians | radius | random | | range_adjacent | range_after | range_before | range_cmp | range_contained_by | range_contains | range_contains_elem | | range_eq | range_ge | range_gt | range_in | range_intersect | range_le | range_lt | | range_minus | range_ne | range_out | range_overlaps | range_overleft | range_overright | range_recv | | range_send | range_typanalyze | range_union | rank | record_eq | record_ge | record_gt | | record_in | record_le | record_lt | record_ne | record_out | record_recv | record_send | | regclass | regclassin | regclassout | regclassrecv | regclasssend | regconfigin | regconfigout | | regconfigrecv | regconfigsend | regdictionaryin | regdictionaryout | regdictionaryrecv | regdictionarysend | regexeqjoinsel | | regexeqsel | regexnejoinsel | regexnesel | regexp_matches | regexp_replace | regexp_split_to_array | regexp_split_to_table | | regoperatorin | regoperatorout | regoperatorrecv | regoperatorsend | regoperin | regoperout | regoperrecv | | regopersend | regprocedurein | regprocedureout | regprocedurerecv | regproceduresend | regprocin | regprocout | | regprocrecv | regprocsend | regr_avgx | regr_avgy | regr_count | regr_intercept | regr_r2 | | regr_slope | regr_sxx | regr_sxy | regr_syy | regtypein | regtypeout | regtyperecv | | regtypesend | reltime | reltimeeq | reltimege | reltimegt | reltimein | reltimele | | reltimelt | reltimene | reltimeout | reltimerecv | reltimesend | repeat | replace | | reverse | RI_FKey_cascade_del | RI_FKey_cascade_upd | RI_FKey_check_ins | RI_FKey_check_upd | RI_FKey_noaction_del | RI_FKey_noaction_upd | | RI_FKey_restrict_del | RI_FKey_restrict_upd | RI_FKey_setdefault_del | RI_FKey_setdefault_upd | RI_FKey_setnull_del | RI_FKey_setnull_upd | right | | round | row_number | row_to_json | rpad | rtrim | scalargtjoinsel | scalargtsel | | scalarltjoinsel | scalarltsel | - | schema_to_xml_and_xmlschema | - | session_user | set_bit | | set_byte | set_config | set_masklen | shift_jis_2004_to_euc_jis_2004 | shift_jis_2004_to_utf8 | sjis_to_euc_jp | sjis_to_mic | | sjis_to_utf8 | smgrin | smgrout | spg_kd_choose | spg_kd_config | spg_kd_inner_consistent | 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_config | | spg_text_inner_consistent | spg_text_leaf_consistent | spg_text_picksplit | spgbeginscan | spgbuild | spgbuildempty | spgbulkdelete | | spgcanreturn | spgcostestimate | spgendscan | spggetbitmap | spggettuple | spginsert | spgmarkpos | | spgoptions | spgrescan | spgrestrpos | spgvacuumcleanup | stddev | stddev_pop | stddev_samp | | string_agg | string_agg_finalfn | string_agg_transfn | strip | sum | suppress_redundant_updates_trigger | - | | - | - | tan | text | text_ge | text_gt | text_larger | | text_le | text_lt | text_pattern_ge | text_pattern_gt | text_pattern_le | text_pattern_lt | text_smaller | | textanycat | textcat | texteq | texticlike | texticnlike | texticregexeq | texticregexne | | textin | textlike | textne | textnlike | textout | textrecv | textregexeq | | textregexne | textsend | thesaurus_init | thesaurus_lexize | tideq | tidge | tidgt | | tidin | tidlarger | tidle | tidlt | tidne | tidout | tidrecv | | tidsend | tidsmaller | time | time_cmp | time_eq | time_ge | time_gt | | time_hash | time_in | time_larger | time_le | time_lt | time_mi_interval | time_mi_time | | time_ne | time_out | time_pl_interval | time_recv | time_send | time_smaller | time_transform | | timedate_pl | timemi | timepl | timestamp | timestamp_cmp | timestamp_cmp_date | timestamp_cmp_timestamptz | | timestamp_eq | timestamp_eq_date | timestamp_eq_timestamptz | timestamp_ge | timestamp_ge_date | timestamp_ge_timestamptz | timestamp_gt | | timestamp_gt_date | timestamp_gt_timestamptz | timestamp_hash | timestamp_in | timestamp_larger | timestamp_le | timestamp_le_date | | timestamp_le_timestamptz | timestamp_lt | timestamp_lt_date | timestamp_lt_timestamptz | timestamp_mi | timestamp_mi_interval | timestamp_ne | | timestamp_ne_date | timestamp_ne_timestamptz | timestamp_out | timestamp_pl_interval | timestamp_recv | timestamp_send | timestamp_smaller | | timestamp_sortsupport | timestamp_transform | timestamptypmodin | timestamptypmodout | timestamptz | timestamptz_cmp | timestamptz_cmp_date | | timestamptz_cmp_timestamp | timestamptz_eq | timestamptz_eq_date | timestamptz_eq_timestamp | timestamptz_ge | timestamptz_ge_date | timestamptz_ge_timestamp | | timestamptz_gt | timestamptz_gt_date | timestamptz_gt_timestamp | timestamptz_in | timestamptz_larger | timestamptz_le | timestamptz_le_date | | timestamptz_le_timestamp | timestamptz_lt | timestamptz_lt_date | timestamptz_lt_timestamp | timestamptz_mi | timestamptz_mi_interval | timestamptz_ne | | timestamptz_ne_date | timestamptz_ne_timestamp | timestamptz_out | timestamptz_pl_interval | timestamptz_recv | timestamptz_send | timestamptz_smaller | | timestamptztypmodin | timestamptztypmodout | timetypmodin | timetypmodout | timetz | timetz_cmp | timetz_eq | | timetz_ge | timetz_gt | timetz_hash | timetz_in | timetz_larger | timetz_le | timetz_lt | | timetz_mi_interval | timetz_ne | timetz_out | timetz_pl_interval | timetz_recv | timetz_send | timetz_smaller | | timetzdate_pl | timetztypmodin | timetztypmodout | timezone（2069） | timezone（1159) | timezone（2037） | timezone (2070) | | timezone (1026) | timezone (2038) | tintervalct | tintervaleq | tintervalge | tintervalgt | tintervalin | | tintervalle | tintervalleneq | tintervallenge | tintervallengt | tintervallenle | tintervallenlt | tintervallenne | | tintervallt | tintervalne | tintervalout | tintervalov | tintervalrecv | tintervalsame | tintervalsend | | tintervalstart | to_ascii（1845） | to_ascii（1847） | to_ascii（1846） | trigger_in | trigger_out | ts_match_qv | | ts_match_tq | ts_match_tt | ts_match_vq | ts_rank | ts_rank_cd | ts_rewrite | ts_stat | | ts_token_type | ts_typanalyze | tsmatchjoinsel | tsmatchsel | tsq_mcontained | tsq_mcontains | tsquery_and | | tsquery_cmp | tsquery_eq | tsquery_ge | tsquery_gt | tsquery_le | tsquery_lt | tsquery_ne | | tsquery_not | tsquery_or | tsqueryin | tsqueryout | tsqueryrecv | tsquerysend | tsrange | | tsrange_subdiff | tstzrange | tstzrange_subdiff | tsvector_cmp | tsvector_concat | tsvector_eq | tsvector_ge | | tsvector_gt | tsvector_le | tsvector_lt | tsvector_ne | tsvector_update_trigger | tsvector_update_trigger_column | tsvectorin | | tsvectorout | tsvectorrecv | tsvectorsend | txid_current | txid_current_snapshot | txid_snapshot_in | txid_snapshot_out | | txid_snapshot_recv | txid_snapshot_send | txid_snapshot_xip | txid_snapshot_xmax | txid_snapshot_xmin | txid_visible_in_snapshot | uhc_to_utf8 | | unique_key_recheck | unknownin | unknownout | unknownrecv | unknownsend | unnest | utf8_to_big5 | | utf8_to_euc_cn | utf8_to_euc_jis_2004 | utf8_to_euc_jp | utf8_to_euc_kr | utf8_to_euc_tw | utf8_to_gb18030 | utf8_to_gbk | | utf8_to_iso8859 | utf8_to_iso8859_1 | utf8_to_johab | utf8_to_koi8r | utf8_to_koi8u | utf8_to_shift_jis_2004 | utf8_to_sjis | | utf8_to_uhc | utf8_to_win | uuid_cmp | uuid_eq | uuid_ge | uuid_gt | uuid_hash | | uuid_in | uuid_le | uuid_lt | uuid_ne | uuid_out | uuid_recv | uuid_send | | var_pop | var_samp | varbit | varbit_in | varbit_out | varbit_recv | varbit_send | | varbit_transform | varbitcmp | varbiteq | varbitge | varbitgt | varbitle | varbitlt | | varbitne | varbittypmodin | varbittypmodout | varchar | varchar_transform | varcharin | varcharout | | varcharrecv | varcharsend | varchartypmodin | varchartypmodout | variance | void_in | void_out | | void_recv | void_send | win_to_utf8 | win1250_to_latin2 | win1250_to_mic | win1251_to_iso | win1251_to_koi8r | | win1251_to_mic | win1251_to_win866 | win866_to_iso | win866_to_koi8r | win866_to_mic | win866_to_win1251 | xideq | | xideqint4 | xidin | xidout | xidrecv | xidsend | xml | xml_in | | - | - | - | xml_out | xml_recv | xml_send | - | | - | xmlconcat2 | - | xmlvalidate | pg_notify | - | - | #### 实现内部功能的函数 下述列表为GaussDB实现系统内部功能所使用的函数，不推荐使用，若需使用，请联系华为技术支持工程师。 - locktag_decode(locktag text) 描述：从locktag中解析锁的具体信息。 返回值类型：text - smgreq(a smgr, b smgr) 描述：比较两个smgr是否一样。 参数：smgr, smgr 返回值类型：boolean - smgrne(a smgr, b smgr) 描述：判断两个smgr是否不一样。 参数：smgr、smgr 返回值类型：boolean - xidin4 描述：输入4字节的xid。 参数：cstring 返回值类型：xid32 - set_hashbucket_info 描述：设置哈希桶信息。 参数：text 返回值类型：boolean - int1send 描述：将无符号一字节整数打包放入内部数据缓冲流。 参数：tinyint 返回值类型：bytea - listagg 描述：list类型agg聚集函数。 参数：smallint、text 返回值类型：text - log_fdw_validator 描述：验证函数。 参数：text\[\]、oid 返回值类型：void - nvarchar2typmodin 描述：获取varchar的typmod信息。 参数：cstring\[\] 返回值类型：integer - nvarchar2typmodout 描述：获取varchar的typmod信息，并构造字符串返回。 参数：integer 返回值类型：cstring - read_disable_conn_file 描述：读取禁止的连接文件。 参数：nan 返回值类型：disconn_mode text、disconn_host text、disconn_port text、local_host text、local_port text、redo_finished text - regex_like_m 描述：正则匹配，判断字符串是否符合给定的正则表达式。 参数：text、text 返回值类型：boolean - update_pgjob 描述：更新job。 参数：bigint、"char"、bigint、timestamp without time zone、timestamp without time zone、timestamp without time zone、timestamp without time zone、timestamp without time zone、smallint、text 返回值类型：void - enum_cmp 描述：枚举类比较函数，用于判断两个枚举类是否相等，以及相对大小。 参数：anyenum、anyenum 返回值类型：integer - enum_eq 描述：枚举类比较函数，用于实现=符号。 参数：anyenum、anyenum 返回值类型：boolean - enum_first 描述：返回枚举类中的第一个元素。 参数：anyenum 返回值类型：anyenum - enum_ge 描述：枚举类比较函数，用于实现\>=符号。 参数：anyenum、anyenum 返回值类型：boolean - enum_gt 描述：枚举类比较函数，用于实现\>符号。 参数：anyenum、anyenum 返回值类型：boolean - enum_in 描述：枚举类比较函数，用于判断元素是否在枚举类中。 参数：cstring、oid 返回值类型：anyenum - enum_larger 描述：枚举类比较函数，用于实现\>符号。 参数：anyenum、anyenum 返回值类型：anyenum - enum_last 描述：返回枚举类中的最后一个元素。 参数：anyenum 返回值类型：anyenum - enum_le 描述：枚举类比较函数，用于实现\<=符号。 参数：anyenum、anyenum 返回值类型：boolean - enum_lt 描述：枚举类比较函数，用于实现\<符号。 参数：anyenum、anyenum 返回值类型：boolean - enum_smaller 描述：枚举类比较函数，用于实现\<符号。 参数：anyenum、anyenum 返回值类型：boolean - node_oid_name 描述：不支持。 参数：oid 返回值类型：cstring - pg_buffercache_pages 描述：从共享buffer缓存里读取数据。 参数：nan 返回值类型：bufferid integer、relfilenode oid、bucketid smallint、reltablespace oid、reldatabase oid、relforknumber smallint、relblocknumber bigint、isdirty boolean、usage_count smallint - pg_check_xidlimit 描述：判断nextxid是否\>= xidwarnlimit。 参数：nan 返回值类型：boolean - gs_validate_ext_listen_ip 描述：清理DN实例上连接无效IP的业务。 参数：详见[表1]。 返回值：bigint pid、text node_name 注意： 当前环境查询该函数时，第一个入参仅支持"normal"，无返回值。 表1GS_VALIDATE_EXT_LISTEN_IP字段 | 名称 | 类型 | 描述 | |:---|:---|:---| | clear | IN cstring | 是否清理，normal表示清理DN实例上连接无效IP的业务。 | | validate_node_name | IN cstring | 指定所要清理IP连接所在DN实例名。 | | validate_ip | IN cstring | 指定所要清理具体的IP。 | | pid | OUT bigint | 被清理的IP连接所在业务线程ID。 | | node_name | OUT text | 被清理的IP连接所在实例名。 | - gs_comm_listen_address_ext_info 描述：显示当前连接listen_address_ext配置扩展IP的DFX信息。 参数：nan 返回值类型：text node_name、text app、bigint tid、integer lwtid、bigint query_id、integer socket、text remote_ip、text remote_port、text local_ip、text local_port。 注意： 当前不支持查询该函数。 表2GS_COMM_LISTEN_ADDRESS_EXT_INFO字段 | 名称 | 类型 | 描述 | |:---|:---|:---| | node_name | OUT text | 描述当前实例名。 | | app | OUT text | 描述当前连接DN的客户端。 | | tid | OUT bigint | 描述当前线程的线程号。 | | lwtid | OUT integer | 描述当前线程的轻量级线程号。 | | query_id | OUT bigint | 描述当前线程的查询ID。 | | socket | OUT integer | 描述当前物理连接的socket fd。 | | remote_ip | OUT text | 描述当前连接对端IP。 | | remote_port | OUT text | 描述当前连接对端port。 | | local_ip | OUT text | 描述当前连接本端IP。 | | local_port | OUT text | 描述当前连接本端port。 | - gs_get_global_listen_address_ext_info() 描述：提供查询全局扩展IP配置信息。 参数：详见[表3]。 返回值类型：text node_name、text host、text port、text ext_listen_ip。 注意： 当前不支持查询该函数。 表3GS_GET_GLOBAL_LISTEN_ADDRESS_EXT_INFO字段 | 名称 | 类型 | 描述 | |:---|:---|:---| | dn_mode | IN cstring | 指定显示的DN范围，null默认查询所有。 | | node_name | OUT text | DN实例名。 | | host | OUT text | DN实例侦听IP。 | | port | OUT text | DN实例侦听port。 | | ext_listen_ip | OUT text | DN实例侦听扩展IP。 | - gs_get_listen_address_ext_info() 描述：提供查询当前DN实例扩展IP配置信息。 参数：nan 返回值类型：text node_name、text host、bigint port、text ext_listen_ip。 注意： 当前不支持查询该函数。 表4GS_GET_LISTEN_ADDRESS_EXT_INFO | 名称 | 类型 | 描述 | |:---|:---|:---| | node_name | OUT text | DN实例名。 | | host | OUT text | DN实例侦听IP。 | | port | OUT bigint | DN实例侦听port。 | | ext_listen_ip | OUT text | DN实例侦听扩展IP。 | - pg_comm_delay 描述：展示单个DN的通信库时延状态。 参数：nan 返回值类型：text、text、integer、integer、integer、integer - pg_comm_recv_stream 描述：展示单个DN上所有的通信库接收流状态。 参数：nan 返回值类型：text、bigint、text、bigint、integer、integer、integer、text、bigint、integer、integer、integer、bigint、bigint、bigint、bigint、bigint - pg_comm_send_stream 描述：展示单个DN上所有的通信库发送流状态。 参数：nan 返回值类型：text、bigint、text、bigint、integer、integer、integer、text、bigint、integer、integer、integer、bigint、bigint、bigint、bigint、bigint - pg_comm_status 描述：展示单个DN的通信状态。 参数：nan 返回值类型：text、integer、integer、bigint、bigint、bigint、bigint、bigint、integer、integer、integer、integer、integer - pg_log_comm_status 描述：在DN上打印一些log。 参数：nan 返回值类型：boolean - pg_parse_clog 描述：解析clog获取xid的status。 参数：nan 返回值类型：xid xid、status text - pg_pool_ping 描述：设置PoolerPing。 参数：boolean 返回值类型：SETOF boolean - pg_resume_bkp_flag 描述：用于备份恢复获取delay xlog标志。 参数：slot_name name 返回值类型：start_backup_flag boolean、to_delay boolean、ddl_delay_recycle_ptr text、rewind_time text - psortoptions 描述：返回psort属性。 参数：text\[\]、boolean 返回值类型：bytea - xideq4 描述：对比两个xid类型的值是否相等。 参数：xid32、xid32 返回值类型：boolean - xideqint8 描述：对比xid类型和int8类型的值是否相等。 参数：xid、bigint 返回值类型：boolean - xidlt 描述：返回xid1 \< xid2是否成立。 参数：xid、xid 返回值类型：boolean - xidlt4 描述：返回xid1 \< xid2是否成立。 参数：xid32、xid32 返回值类型：boolean - gs_shutdown_cross_region_walsenders 描述：中断跨集群流式复制。 参数：nan 返回值类型：void 备注：调用该函数的用户需要具有SYSADMIN权限或具有OPRADMIN权限，运维管理员角色须打开operate_mode。 - is_dblink_in_transaction 描述：判断当前事务中是否使用了oid对应的DATABASE LINK。 参数：oid 返回值类型：boolean - dblink_has_updatasent 描述：判断当前事务中是否使用oid对应的DATABASE LINK发送了dml语句且未提交。 参数：oid 返回值类型：boolean - get_last_xmin_by_oid 描述：通过表的oid获取该表所有字段中最大的xmin值。 参数：oid 返回值类型：xid - get_relid_by_relname 描述：通过表的表名及relnamespace获取表的oid。 参数：cstring, oid 返回值类型：oid - copy_summary_create 描述：copy_summary_create用于创建gs_copy_summary表。 参数：无 返回值类型：text