其他系统函数
其他系统函数包含两类,兼容PostgreSQL的函数和实现内部功能的函数。这些函数不推荐使用,若需使用,请联系华为技术支持工程师。
兼容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_eq |
range_ge |
range_gt |
range_in |
range_intersect |
range_le |
range_lt |
range_minus |
range_ne |
range_out |
range_overlaps |
range_overleft |
range_overright |
range_recv |
range_send |
range_typanalyze |
range_union |
rank |
record_eq |
record_ge |
record_gt |
record_in |
record_le |
record_lt |
record_ne |
record_out |
record_recv |
record_send |
regclass |
regclassin |
regclassout |
regclassrecv |
regclasssend |
regconfigin |
regconfigout |
regconfigrecv |
regconfigsend |
regdictionaryin |
regdictionaryout |
regdictionaryrecv |
regdictionarysend |
regexeqjoinsel |
regexeqsel |
regexnejoinsel |
regexnesel |
regexp_matches |
regexp_replace |
regexp_split_to_array |
regexp_split_to_table |
regoperatorin |
regoperatorout |
regoperatorrecv |
regoperatorsend |
regoperin |
regoperout |
regoperrecv |
regopersend |
regprocedurein |
regprocedureout |
regprocedurerecv |
regproceduresend |
regprocin |
regprocout |
regprocrecv |
regprocsend |
regr_avgx |
regr_avgy |
regr_count |
regr_intercept |
regr_r2 |
regr_slope |
regr_sxx |
regr_sxy |
regr_syy |
regtypein |
regtypeout |
regtyperecv |
regtypesend |
reltime |
reltimeeq |
reltimege |
reltimegt |
reltimein |
reltimele |
reltimelt |
reltimene |
reltimeout |
reltimerecv |
reltimesend |
repeat |
replace |
reverse |
RI_FKey_cascade_del |
RI_FKey_cascade_upd |
RI_FKey_check_ins |
RI_FKey_check_upd |
RI_FKey_noaction_del |
RI_FKey_noaction_upd |
RI_FKey_restrict_del |
RI_FKey_restrict_upd |
RI_FKey_setdefault_del |
RI_FKey_setdefault_upd |
RI_FKey_setnull_del |
RI_FKey_setnull_upd |
right |
round |
row_number |
row_to_json |
rpad |
rtrim |
scalargtjoinsel |
scalargtsel |
scalarltjoinsel |
scalarltsel |
- |
schema_to_xml_and_xmlschema |
- |
session_user |
set_bit |
set_byte |
set_config |
set_masklen |
shift_jis_2004_to_euc_jis_2004 |
shift_jis_2004_to_utf8 |
sjis_to_euc_jp |
sjis_to_mic |
sjis_to_utf8 |
smgrin |
smgrout |
spg_kd_choose |
spg_kd_config |
spg_kd_inner_consistent |
spg_kd_picksplit |
spg_quad_choose |
spg_quad_config |
spg_quad_inner_consistent |
spg_quad_leaf_consistent |
spg_quad_picksplit |
spg_text_choose |
spg_text_config |
spg_text_inner_consistent |
spg_text_leaf_consistent |
spg_text_picksplit |
spgbeginscan |
spgbuild |
spgbuildempty |
spgbulkdelete |
spgcanreturn |
spgcostestimate |
spgendscan |
spggetbitmap |
spggettuple |
spginsert |
spgmarkpos |
spgoptions |
spgrescan |
spgrestrpos |
spgvacuumcleanup |
stddev |
stddev_pop |
stddev_samp |
string_agg |
string_agg_finalfn |
string_agg_transfn |
strip |
sum |
suppress_redundant_updates_trigger |
- |
- |
- |
tan |
text |
text_ge |
text_gt |
text_larger |
text_le |
text_lt |
text_pattern_ge |
text_pattern_gt |
text_pattern_le |
text_pattern_lt |
text_smaller |
textanycat |
textcat |
texteq |
texticlike |
texticnlike |
texticregexeq |
texticregexne |
textin |
textlike |
textne |
textnlike |
textout |
textrecv |
textregexeq |
textregexne |
textsend |
thesaurus_init |
thesaurus_lexize |
tideq |
tidge |
tidgt |
tidin |
tidlarger |
tidle |
tidlt |
tidne |
tidout |
tidrecv |
tidsend |
tidsmaller |
time |
time_cmp |
time_eq |
time_ge |
time_gt |
time_hash |
time_in |
time_larger |
time_le |
time_lt |
time_mi_interval |
time_mi_time |
time_ne |
time_out |
time_pl_interval |
time_recv |
time_send |
time_smaller |
time_transform |
timedate_pl |
timemi |
timepl |
timestamp |
timestamp_cmp |
timestamp_cmp_date |
timestamp_cmp_timestamptz |
timestamp_eq |
timestamp_eq_date |
timestamp_eq_timestamptz |
timestamp_ge |
timestamp_ge_date |
timestamp_ge_timestamptz |
timestamp_gt |
timestamp_gt_date |
timestamp_gt_timestamptz |
timestamp_hash |
timestamp_in |
timestamp_larger |
timestamp_le |
timestamp_le_date |
timestamp_le_timestamptz |
timestamp_lt |
timestamp_lt_date |
timestamp_lt_timestamptz |
timestamp_mi |
timestamp_mi_interval |
timestamp_ne |
timestamp_ne_date |
timestamp_ne_timestamptz |
timestamp_out |
timestamp_pl_interval |
timestamp_recv |
timestamp_send |
timestamp_smaller |
timestamp_sortsupport |
timestamp_transform |
timestamptypmodin |
timestamptypmodout |
timestamptz |
timestamptz_cmp |
timestamptz_cmp_date |
timestamptz_cmp_timestamp |
timestamptz_eq |
timestamptz_eq_date |
timestamptz_eq_timestamp |
timestamptz_ge |
timestamptz_ge_date |
timestamptz_ge_timestamp |
timestamptz_gt |
timestamptz_gt_date |
timestamptz_gt_timestamp |
timestamptz_in |
timestamptz_larger |
timestamptz_le |
timestamptz_le_date |
timestamptz_le_timestamp |
timestamptz_lt |
timestamptz_lt_date |
timestamptz_lt_timestamp |
timestamptz_mi |
timestamptz_mi_interval |
timestamptz_ne |
timestamptz_ne_date |
timestamptz_ne_timestamp |
timestamptz_out |
timestamptz_pl_interval |
timestamptz_recv |
timestamptz_send |
timestamptz_smaller |
timestamptztypmodin |
timestamptztypmodout |
timetypmodin |
timetypmodout |
timetz |
timetz_cmp |
timetz_eq |
timetz_ge |
timetz_gt |
timetz_hash |
timetz_in |
timetz_larger |
timetz_le |
timetz_lt |
timetz_mi_interval |
timetz_ne |
timetz_out |
timetz_pl_interval |
timetz_recv |
timetz_send |
timetz_smaller |
timetzdate_pl |
timetztypmodin |
timetztypmodout |
timezone(2069) |
timezone(1159) |
timezone(2037) |
timezone (2070) |
timezone (1026) |
timezone (2038) |
tintervalct |
tintervaleq |
tintervalge |
tintervalgt |
tintervalin |
tintervalle |
tintervalleneq |
tintervallenge |
tintervallengt |
tintervallenle |
tintervallenlt |
tintervallenne |
tintervallt |
tintervalne |
tintervalout |
tintervalov |
tintervalrecv |
tintervalsame |
tintervalsend |
tintervalstart |
to_ascii(1845) |
to_ascii(1847) |
to_ascii(1846) |
trigger_in |
trigger_out |
ts_match_qv |
ts_match_tq |
ts_match_tt |
ts_match_vq |
ts_rank |
ts_rank_cd |
ts_rewrite |
ts_stat |
ts_token_type |
ts_typanalyze |
tsmatchjoinsel |
tsmatchsel |
tsq_mcontained |
tsq_mcontains |
tsquery_and |
tsquery_cmp |
tsquery_eq |
tsquery_ge |
tsquery_gt |
tsquery_le |
tsquery_lt |
tsquery_ne |
tsquery_not |
tsquery_or |
tsqueryin |
tsqueryout |
tsqueryrecv |
tsquerysend |
tsrange |
tsrange_subdiff |
tstzrange |
tstzrange_subdiff |
tsvector_cmp |
tsvector_concat |
tsvector_eq |
tsvector_ge |
tsvector_gt |
tsvector_le |
tsvector_lt |
tsvector_ne |
tsvector_update_trigger |
tsvector_update_trigger_column |
tsvectorin |
tsvectorout |
tsvectorrecv |
tsvectorsend |
txid_current |
txid_current_snapshot |
txid_snapshot_in |
txid_snapshot_out |
txid_snapshot_recv |
txid_snapshot_send |
txid_snapshot_xip |
txid_snapshot_xmax |
txid_snapshot_xmin |
txid_visible_in_snapshot |
uhc_to_utf8 |
unique_key_recheck |
unknownin |
unknownout |
unknownrecv |
unknownsend |
unnest |
utf8_to_big5 |
utf8_to_euc_cn |
utf8_to_euc_jis_2004 |
utf8_to_euc_jp |
utf8_to_euc_kr |
utf8_to_euc_tw |
utf8_to_gb18030 |
utf8_to_gbk |
utf8_to_iso8859 |
utf8_to_iso8859_1 |
utf8_to_johab |
utf8_to_koi8r |
utf8_to_koi8u |
utf8_to_shift_jis_2004 |
utf8_to_sjis |
utf8_to_uhc |
utf8_to_win |
uuid_cmp |
uuid_eq |
uuid_ge |
uuid_gt |
uuid_hash |
uuid_in |
uuid_le |
uuid_lt |
uuid_ne |
uuid_out |
uuid_recv |
uuid_send |
var_pop |
var_samp |
varbit |
varbit_in |
varbit_out |
varbit_recv |
varbit_send |
varbit_transform |
varbitcmp |
varbiteq |
varbitge |
varbitgt |
varbitle |
varbitlt |
varbitne |
varbittypmodin |
varbittypmodout |
varchar |
varchar_transform |
varcharin |
varcharout |
varcharrecv |
varcharsend |
varchartypmodin |
varchartypmodout |
variance |
void_in |
void_out |
void_recv |
void_send |
win_to_utf8 |
win1250_to_latin2 |
win1250_to_mic |
win1251_to_iso |
win1251_to_koi8r |
win1251_to_mic |
win1251_to_win866 |
win866_to_iso |
win866_to_koi8r |
win866_to_mic |
win866_to_win1251 |
xideq |
xideqint4 |
xidin |
xidout |
xidrecv |
xidsend |
xml |
xml_in |
- |
- |
- |
xml_out |
xml_recv |
xml_send |
- |
- |
xmlconcat2 |
- |
xmlvalidate |
pg_notify |
- |
- |
实现内部功能的函数
下述列表为GaussDB实现系统内部功能所使用的函数,不推荐使用,若需使用,请联系华为技术支持工程师。
- smgreq(a smgr, b smgr)
参数:smgr, smgr
返回值类型:boolean
- smgrne(a smgr, b smgr)
参数:smgr、smgr
返回值类型:boolean
- xidin4
参数:cstring
返回值类型:xid32
- set_hashbucket_info
参数:text
返回值类型:boolean
- int1send
参数:tinyint
返回值类型:bytea
- listagg
参数:smallint、text
返回值类型:text
- log_fdw_validator
参数:text[]、oid
返回值类型:void
- nvarchar2typmodin
参数:cstring[]
返回值类型:integer
- nvarchar2typmodout
描述:获取varchar的typmod信息,并构造字符串返回。
参数:integer
返回值类型:cstring
- read_disable_conn_file
参数:nan
返回值类型:disconn_mode text、disconn_host text、disconn_port text、local_host text、local_port text、redo_finished text
- regex_like_m
参数:text、text
返回值类型:boolean
- update_pgjob
参数:bigint、"char"、bigint、timestamp without time zone、timestamp without time zone、timestamp without time zone、timestamp without time zone、timestamp without time zone、smallint、text
返回值类型:void
- enum_cmp
描述:枚举类比较函数,用于判断两个枚举类是否相等,以及相对大小。
参数:anyenum、anyenum
返回值类型:integer
- enum_eq
参数:anyenum、anyenum
返回值类型:boolean
- enum_first
参数:anyenum
返回值类型:anyenum
- enum_ge
参数:anyenum、anyenum
返回值类型:boolean
- enum_gt
参数:anyenum、anyenum
返回值类型:boolean
- enum_in
参数:cstring、oid
返回值类型:anyenum
- enum_larger
参数:anyenum、anyenum
返回值类型:anyenum
- enum_last
参数:anyenum
返回值类型:anyenum
- enum_le
参数:anyenum、anyenum
返回值类型:boolean
- enum_lt
参数:anyenum、anyenum
返回值类型:boolean
- enum_smaller
参数:anyenum、anyenum
返回值类型:boolean
- node_oid_name
参数:oid
返回值类型:cstring
- pg_buffercache_pages
参数:nan
返回值类型:bufferid integer、relfilenode oid、bucketid smallint、reltablespace oid、reldatabase oid、relforknumber smallint、relblocknumber bigint、isdirty boolean、usage_count smallint
- pg_check_xidlimit
描述:判断nextxid是否>= xidwarnlimit。
参数:nan
返回值类型:boolean
- gs_validate_ext_listen_ip
参数:详见表1。
返回值:bigint pid、text node_name
注意: 当前环境查询该函数时,第一个入参仅支持“normal”,无返回值。
- gs_comm_listen_address_ext_info
描述:显示当前连接listen_address_ext配置扩展IP的DFX信息。
参数:nan
返回值类型:text node_name、text app、bigint tid、integer lwtid、bigint query_id、integer socket、text remote_ip、text remote_port、text local_ip、text local_port。
注意: 当前不支持查询该函数。
表2 GS_COMM_LISTEN_ADDRESS_EXT_INFO字段 名称
类型
描述
node_name
OUT text
描述当前实例名。
app
OUT text
描述当前连接DN的客户端。
tid
OUT bigint
描述当前线程的线程号。
lwtid
OUT integer
描述当前线程的轻量级线程号。
query_id
OUT bigint
描述当前线程的查询ID。
socket
OUT integer
描述当前物理连接的socket fd。
remote_ip
OUT text
描述当前连接对端IP。
remote_port
OUT text
描述当前连接对端port。
local_ip
OUT text
描述当前连接本端IP。
local_port
OUT text
描述当前连接本端port。
- gs_get_global_listen_address_ext_info()
参数:详见表3。
返回值类型:text node_name、text host、text port、text ext_listen_ip。
注意: 当前不支持查询该函数。
- gs_get_listen_address_ext_info()
参数:nan
返回值类型:text node_name、text host、bigint port、text ext_listen_ip。
注意: 当前不支持查询该函数。
表4 GS_GET_LISTEN_ADDRESS_EXT_INFO 名称
类型
描述
node_name
OUT text
DN实例名。
host
OUT text
DN实例侦听IP。
port
OUT bigint
DN实例侦听port。
ext_listen_ip
OUT text
DN实例侦听扩展IP。
- pg_comm_delay
参数:nan
返回值类型:text、text、integer、integer、integer、integer
- pg_comm_recv_stream
参数:nan
返回值类型:text、bigint、text、bigint、integer、integer、integer、text、bigint、integer、integer、integer、bigint、bigint、bigint、bigint、bigint
- pg_comm_send_stream
参数:nan
返回值类型:text、bigint、text、bigint、integer、integer、integer、text、bigint、integer、integer、integer、bigint、bigint、bigint、bigint、bigint
- pg_comm_status
参数:nan
返回值类型:text、integer、integer、bigint、bigint、bigint、bigint、bigint、integer、integer、integer、integer、integer
- pg_log_comm_status
参数:nan
返回值类型:boolean
- pg_parse_clog
参数:nan
返回值类型:xid xid、status text
- pg_pool_ping
参数:boolean
返回值类型:SETOF boolean
- pg_resume_bkp_flag
参数:slot_name name
返回值类型:start_backup_flag boolean、to_delay boolean、ddl_delay_recycle_ptr text、rewind_time text
- psortoptions
参数:text[]、boolean
返回值类型:bytea
- xideq4
参数:xid32、xid32
返回值类型:boolean
- xideqint8
参数:xid、bigint
返回值类型:boolean
- xidlt
参数:xid、xid
返回值类型:boolean
- xidlt4
参数:xid32、xid32
返回值类型:boolean
- gs_shutdown_cross_region_walsenders
参数:nan
返回值类型:void
备注:调用该函数的用户需要具有SYSADMIN权限或具有OPRADMIN权限,运维管理员角色须打开operate_mode。
- is_dblink_in_transaction
描述:判断当前事务中是否使用了oid对应的DATABASE LINK。
参数:oid
返回值类型:boolean
- dblink_has_updatasent
描述:判断当前事务中是否使用oid对应的DATABASE LINK发送了dml语句且未提交。
参数:oid
返回值类型:boolean
- get_last_xmin_by_oid
参数:oid
返回值类型:xid
- get_relid_by_relname
描述:通过表的表名及relnamespace获取表的oid。
参数:cstring, oid
返回值类型:oid
- copy_summary_create
描述:copy_summary_create用于创建gs_copy_summary表。
参数:无
返回值类型:text