文档中心
MogDBMogDB StackUqbar
生态工具
v3.0
文档目录
文档:v3.0

其他系统函数

MogDB的内建函数和操作符继承自开源PG,下述函数不作赘述,详情请参见PG官方文档

_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
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 - - gin_clean_pending_list gin_cmp_prefix gin_cmp_tslexeme
gin_extract_tsquery gin_extract_tsvector gin_tsquery_consistent gin_tsquery_triconsistent ginarrayconsistent ginarrayextract ginarraytriconsistent
ginbeginscan ginbuild ginbuildempty ginbulkdelete gincostestimate ginendscan gingetbitmap
gininsert ginmarkpos ginoptions ginqueryarrayextract ginrescan ginrestrpos ginvacuumcleanup
gist_box_compress gist_box_consistent gist_box_decompress gist_box_penalty gist_box_picksplit gist_box_same gist_box_union
gist_circle_compress gist_circle_consistent gist_point_compress gist_point_consistent gist_point_distance gist_poly_compress gist_poly_consistent
gistbeginscan gistbuild gistbuildempty gistbulkdelete gistcostestimate gistendscan gistgetbitmap
gistgettuple gistinsert gistmarkpos gistoptions gistrescan gistrestrpos gistvacuumcleanup
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 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 xpath 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 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_eq range_ge range_gist_compress range_gist_consistent range_gist_decompress range_gist_penalty range_gist_picksplit
range_gist_same range_gist_union 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 pg_notify - -

下述列表为MogDB实现系统内部功能所使用的函数,不推荐使用,若需使用,请联系云和恩墨技术支持工程师。

  • pv_compute_pool_workload()

    描述:提供云上加速集群当前负载信息。

    返回值类型:record

  • locktag_decode(locktag text)

    描述:从locktag中解析锁的具体信息。

    返回值类型:text

  • smgreq(a smgr, b smgr)

    描述:比较两个smgr是否一样。

    参数:smgr, smgr

    返回值类型:boolean

  • smgrne(a smgr, b smgr)

    描述:判断两个smgr是否不一样。

    参数:smgr, smgr

    返回值类型:boolean

  • xidin4

    描述:输入4字节的xid。

    参数:cstring

    返回值类型:xid32

  • set_hashbucket_info

    描述:设置哈希桶信息。

    参数:text

    返回值类型:boolean

  • hs_concat

    描述:拼接两个hstore类型数据。

    参数:hstore, hstore

    返回值类型:hstore

  • hs_contained

    描述:判断两个hstore类型数据是否包含,返回值布尔类型。

    参数:hstore, hstore

    返回值类型:boolean

  • hs_contains

    描述:判断两个hstore类型数据是否包含,返回值布尔类型。

    参数:hstore, hstore

    返回值类型:boolean

  • hstore

    描述:将参数转为hstore类型。

    参数:text, text

    返回值类型:hstore

  • hstore_in

    描述:以string格式接收hstore数据。

    参数:cstring

    返回值类型:hstore

  • hstore_out

    描述:以string格式发送hstore数据。

    参数:hstore

    返回值类型:cstring

  • hstore_send

    描述:以bytea格式发送hstore数据。

    参数:hstore

    返回值类型:bytea

  • hstore_to_array

    描述:以text数组格式发送hstore数据。

    参数:hstore

    返回值类型:text[]

  • hstore_to_matrix

    描述:以text数组格式发送hstore数据。

    参数:hstore

    返回值类型:text[]

  • hstore_version_diag

    描述:以integer数组格式发送hstore数据。

    参数:hstore

    返回值类型:integer

  • int1send

    描述:将无符号一字节整数打包放入内部数据缓冲流。

    参数:tinyint

    返回值类型:bytea

  • isdefined

    描述:判断指定key是否存在。

    参数:hstore, text

    返回值类型:boolean

  • listagg

    描述:list类型agg聚集函数。

    参数:smallint, text

    返回值类型:text

  • log_fdw_validator

    描述:验证函数。

    参数:text[], oid

    返回值类型:void

  • nvarchar2typmodin

    描述:获取varchar的typmod信息。

    参数:cstring[]

    返回值类型:integer

  • nvarchar2typmodout

    描述:获取varchar的typmod信息,并构造字符串返回。

    参数:integer

    返回值类型:cstring

  • read_disable_conn_file

    描述:读取禁止的连接文件。

    参数:nan

    返回值类型:disconn_mode text, disconn_host text, disconn_port text, local_host text, local_port text, redo_finished text

  • regex_like_m

    描述:正则匹配,判断字符串是否符合给定的正则表达式。

    参数:text, text

    返回值类型:boolean

  • update_pgjob

    描述:更新job。

    参数:bigint, “char”, bigint, timestamp without time zone, timestamp without time zone, timestamp without time zone, timestamp without time zone, timestamp without time zone, smallint

    返回值类型: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

    返回值类型:setof record

    返回字段说明如下:

    名称 类型 描述
    bufferid integer 缓冲区的内部ID。
    relfilenode oid 缓冲区中页面所属关系的OID。
    bucketid integer 缓冲区所处的哈希桶号。
    storage_type bigint 缓冲区中数据的存储类型。
    reltablespace oid 缓冲区中数据所处的表空间的OID。
    reldatabase oid 缓冲区中数据所处的数据库的OID。
    relforknumber integer 缓冲区中数据所在的关系文件分支类型。
    relblocknumber integer 缓冲区中数据在其所属关系文件中的文件块号。
    isdirty boolean 缓冲区是否为脏。
    isvalid boolean 缓冲区是否有效。
    usage_count smallint 缓冲区的使用计数。
    pinning_backends integer 正在使用缓冲区的后端数。
  • pg_check_xidlimit

    描述:判断nextxid是否>= xidwarnlimit。

    参数:nan

    返回值类型:boolean

  • pg_comm_delay

    描述:展示单个DN的通信库时延状态。

    参数:nan

    返回值类型:text, text, integer, integer, integer, integer

  • pg_comm_recv_stream

    描述:展示单个DN上所有的通信库接收流状态。

    参数:nan

    返回值类型:text, bigint, text, bigint, integer, integer, integer, text, bigint, integer, integer, integer, bigint, bigint, bigint, bigint, bigint

  • pg_comm_send_stream

    描述:展示单个DN上所有的通信库发送流状态。

    参数:nan

    返回值类型:text, bigint, text, bigint, integer, integer, integer, text, bigint, integer, integer, integer, bigint, bigint, bigint, bigint, bigint

  • pg_comm_status

    描述: 展示单个DN的通信状态。

    参数:nan

    返回值类型:text, integer, integer, bigint, bigint, bigint, bigint, bigint, integer, integer, integer, integer, integer

  • pg_log_comm_status

    描述:在DN上打印一些log。

    参数:nan

    返回值类型:boolean

  • pg_parse_clog

    描述:解析clog获取xid的status。

    参数:nan

    返回值类型:xid xid, status text

  • pg_pool_ping

    描述:设置PoolerPing。

    参数:boolean

    返回值类型:SETOF boolean

  • pg_resume_bkp_flag

    描述:用于备份恢复获取delay xlong标志。

    参数:slot_name name

    返回值类型:start_backup_flag boolean, to_delay boolean, ddl_delay_recycle_ptr text, rewind_time text

  • pgfadvise_DONTNEED

    描述:这个函数为当前关系设置DONTNEED标记。这意味着如果需要释放一些内存,操作系统会首先卸载该文件的页。主要思想是卸载不再使用的文件(而不是可能会被使用的页面)。

    示例:

    MogDB=# select * from pgfadvise_dontneed('pgbench_accounts');
          relpath       | os_page_size | rel_os_pages | os_pages_free
    --------------------+--------------+--------------+---------------
     base/11874/16447   |         4096 |       262144 |        342071
     base/11874/16447.1 |         4096 |        65726 |        408103
  • pgfadvise_WILLNEED

    描述:这个函数为当前关系设置WILLNEED标记。这意味着操作系统将尝试加载该关系尽可能多的页面。主要思想是在服务器启动时预加载文件,预加载文件时可能使用缓存命中率/失误率以及最可能被使用的关系/索引等信息。

    示例:

    MogDB=# select * from pgfadvise_willneed('pgbench_accounts');
          relpath       | os_page_size | rel_os_pages | os_pages_free 
    --------------------+--------------+--------------+---------------
     base/11874/16447   |         4096 |       262144 |         80650
     base/11874/16447.1 |         4096 |        65726 |         80650
  • pgfadvise_NORMAL

    描述:这个函数为当前关系设置NORMAL标记。

  • pgfadvise_SEQUENTIAL

    描述:这个函数为当前关系设置SEQUENTIAL标记。

  • pgfadvise_RANDOM

    描述:这个函数为当前关系设置RANDOM标记。

  • pgfadvise_loader

    描述:这个函数允许直接与页面缓存交互。它可以用于根据表示要加载/卸载的页面映射的varbit从内存加载和/或卸载页面。

    示例:该示例使用的关系名称为pgbench_accounts, 段号为0以及任意的varbit映射

    -- 加载与卸载
    MogDB=# select * from pgfadvise_loader('pgbench_accounts', 0, true, true, B'111000');
         relpath      | os_page_size | os_pages_free | pages_loaded | pages_unloaded 
    ------------------+--------------+---------------+--------------+----------------
     base/11874/16447 |         4096 |        408376 |            3 |              3
    
    -- 加载
    MogDB=# select * from pgfadvise_loader('pgbench_accounts', 0, true, false, B'111000');
         relpath      | os_page_size | os_pages_free | pages_loaded | pages_unloaded 
    ------------------+--------------+---------------+--------------+----------------
     base/11874/16447 |         4096 |        408370 |            3 |              0
    
    -- 卸载
    MogDB=# select * from pgfadvise_loader('pgbench_accounts', 0, false, true, B'111000');
         relpath      | os_page_size | os_pages_free | pages_loaded | pages_unloaded 
    ------------------+--------------+---------------+--------------+----------------
     base/11874/16447 |         4096 |        408370 |            0 |              3
  • pgfincore

    描述:这个函数提供关于文件系统缓存(页面缓存)的信息。

    示例:

    MogDB=# select * from pgfincore('pgbench_accounts');
         relpath       | segment | os_page_size | rel_os_pages | pages_mem | group_mem | os_pages_free | databit | pages_dirty | group_dirty  
      --------------------+---------+--------------+--------------+-----------+-----------+---------------+---------+-------------+-------------
     base/11874/16447   |       0 |         4096 |       262144 |         3 |         1 |        408444 |         |           0 |           0
     base/11874/16447.1 |       1 |         4096 |        65726 |         0 |         0 |        408444 |         |           0 |           0

    对于一个指定的关系,该函数返回包括以下字段:

    • relpath : 该关系的路径
    • segment : 被分析的段号
    • os_page_size : 一个页面的大小
    • rel_os_pages : 该关系的总页面数
    • pages_mem : 关系在页面缓存中的页面总数。 (不是来自PostgreSQL的共享缓冲区,而是操作系统缓存)
    • group_mem : 相邻pages_mem的组数
    • os_page_free : 操作系统页面缓存中空闲的页面数
    • databit : 该文件的varbit映射,因为该字段的大小关系,若需要输出该字段,需要使用pgfincore('pgbench_accounts',true)来激活它。
    • pages_dirty : 如果定义了HAVE_FINCORE常量,平台将提供相关的信息,和pages_mem类似,只不过是对于脏页面的
    • group_dirty : 如果定义了HAVE_FINCORE常量,平台将提供相关的信息,和group_mem类似,只不过是对于脏页面的
  • pgsysconf

    描述:这个函数输出操作系统块的大小,操作系统页面缓冲区中空闲页面的数量。

    示例:

    MogDB=# select * from pgsysconf();
     os_page_size | os_pages_free | os_total_pages 
    --------------+---------------+----------------
             4096 |         80431 |        4094174
  • pgsysconf_pretty

    描述:该函数的功能同上,不同之处在于该函数进行了单位转换,便于阅读。

    示例:

    MogDB=# select * from pgsysconf_pretty();
     os_page_size | os_pages_free | os_total_pages 
    --------------+---------------+----------------
     4096 bytes   | 314 MB        | 16 GB
  • pgfincore_drawer

    描述:一个非常简单的渲染器。这个函数需要一个varbit类型的参数。通常,这个参数的值来源于pgfincore函数的databit返回字段。databit字段的值由0和1组成,如果是0,意味着该页不在操作系统页面缓存中,如果是1,则意味着该页在操作系统页面缓存中。

    示例:

    MogDB=# select * from pgfincore_drawer(B'000111');
     drawer       
    --------------
        ...     
    
    MogDB=# select * from pgfincore_drawer(B'111000');
     drawer       
    --------------
     ... 
  • psortoptions

    描述:返回psort属性。

    参数:text[], boolean

    返回值类型:bytea

  • xideq4

    描述:对比两个xid类型的值是否相等。

    参数:xid32, xid32

    返回值类型:boolean

  • xideqint8

    描述:对比xid类型和int8类型的值是否相等。

    参数:xid, bigint

    返回值类型:boolean

  • xidlt

    描述:返回xid1 < xid2是否成立。

    参数:xid, xid

    返回值类型:boolean

  • xidlt4

    描述:返回xid1 < xid2是否成立。

    参数:xid32, xid32

    返回值类型:boolean

Copyright © 2009-2022 www.enmotech.com All rights reserved.