# 兼容PostgreSQL的函数和操作符 下述列表为GaussDB的内建函数和操作符兼容PostgreSQL。 | _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_ge | range_eq | 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 | year_in | year_out | | year_recv | year_send | yeartypmodin | yeartypmodout | year_eq | year_ne | year_lt | | year_le | year_gt | year_ge | year_cmp | year_hash | year_larger | year_smaller | | year_mi | year_mi_int4 | int4_mi_year | year_pl | year_pl_int4 | int4_pl_year | int4_year | | year_int4 | date_year | numeric_year | text_year | time_year | timestamp_year | timestamptz_year | | lpad_s | int8numericle | int8numericge | btint12cmp | btint14cmp | btint18cmp | btint116cmp | | btint1numericcmp | btint21cmp | btint216cmp | btint2numericcmp | btint41cmp | btint416cmp | btint4numericcmp | | btint81cmp | btint816cmp | btint8numericcmp | btint161cmp | btint162cmp | btint164cmp | btint168cmp | | btnumericint1cmp | btnumericint2cmp | btnumericint4cmp | btnumericint8cmp | btint16cmp | hashint16 | hashint1_numeric | | hashint2_numeric | hashint4_numeric | hashint8_numeric | int12eq | int12ne | int12lt | int12gt | | int12le | int12ge | int14eq | int14ne | int14lt | int14gt | int14le | | int14ge | int18eq | int18ne | int18lt | int18gt | int18le | int18ge | | int116eq | int116ne | int116lt | int116gt | int116le | int116ge | int1numericeq | | int1numericne | int1numericlt | int1numericgt | int1numericle | int1numericge | numericint1eq | numericint1ne | | numericint1ne | numericint1gt | numericint1le | numericint1ge | numericint2eq | numericint2ne | numericint2lt | | numericint2gt | numericint2le | numericint2ge | numericint4eq | numericint4ne | numericint4lt | numericint4gt | | numericint4le | numericint4ge | numericint8eq | numericint8ne | numericint8lt | numericint8gt | numericint8le | | numericint8ge | int161eq | int161ne | int161lt | int161gt | int161le | int161ge | | int162eq | int162ne | int162lt | int162gt | int162le | int162ge | int164eq | | int164ne | int164lt | int164gt | int164le | int164ge | int168eq | int168ne | | int168lt | int168gt | int168le | int168ge | int21eq | int21ne | int21lt | | int21gt | int21le | int21ge | int216eq | int216ne | int216lt | int216gt | | int216le | int216ge | int2numericeq | int2numericne | int2numericlt | int2numericgt | int2numericle | | int2numericge | int41eq | int41ne | int41lt | int41gt | int41le | int41ge | | int416eq | int416ne | int416lt | int416gt | int416le | int416ge | int4numericeq | | int4numericne | int4numericlt | int4numericgt | int4numericle | int4numericge | int81eq | int81ne | | int81lt | int81gt | int81le | int81ge | int816eq | int816ne | int816lt | | int816gt | int816le | int816ge | int8numericeq | int8numericne | int8numericlt | int8numericgt | | bpcharlikebpchar | bpcharnlikebpchar | pg_stat_get_db_conflict_force_recycle | pg_stat_get_db_conflict_standby_query_timeout | pg_stat_get_db_conflict_truncate | - | - | ![](https://support.huaweicloud.com/centralized-devg-v8-gaussdb/public_sys-resources/note_3.0-zh-cn.png) 升级模式下，不支持调用变长参数的系统函数，如concat。