# 兼容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                 | q                              | 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                       |
| xpath_exists                     | current_setting                                                                                                   | current_user                      | currtid                        | currtid2                       | currval                            | cursor_to_xml                        |
| cursor_to_xmlschema              | database_to_xml                                                                                                   | database_to_xml_and_xmlschema     | database_to_xmlschema          | 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                                                                                             | get_global_gs_asp                 | get_large_table_name           | -                              | -                                  | -                                    |
| 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+1635:1668_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_notify                      | pg_stat_get_wal_receiver       | 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                    | xpath                          | pg_timezone_abbrevs            | pg_timezone_names                  | pgxc_node_str                        |
| 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              | query_to_xml                       | query_to_xml_and_xmlschema           |
| query_to_xmlschema               | 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                     | schema_to_xml_and_xmlschema    | schema_to_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 | table_to_xml                         |
| table_to_xml_and_xmlschema       | table_to_xmlschema                                                                                                | 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_is_well_formed               | xml_is_well_formed_content                                                                                        | xml_is_well_formed_document       | xml_out                        | xml_recv                       | xml_send                           | xmlagg                               |
| xmlcomment                       | xmlconcat2                                                                                                        | xmlexists                         | xmlvalidate                    | -                              | 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                     |
| bpcharlikebpchar                 | bpcharnlikebpchar                                                                                                 | -                                 | -                              | -                              | -                                  | -                                    |
   
![](https://support.huaweicloud.com/distributed-devg-v8-gaussdb/public_sys-resources/note_3.0-zh-cn.png)
升级模式下，不支持调用变长参数的系统函数，如concat。