其他系统函数
- 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
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+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_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_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
-
-
-
下述列表为GaussDB实现系统内部功能所使用的函数,不推荐使用,若需使用,请联系华为技术支持工程师。
- smgreq(a smgr, b smgr)
参数:smgr, smgr
返回值类型:boolean
- smgrne(a smgr, b smgr)
参数:smgr, smgr
返回值类型:boolean
- spread_collect
描述:该函数用于计算某段时间内最大和最小值得差值,用于聚合函数的数据收集过程。
参数:s real[], v real[]
返回值类型:real[]
- spread_final
描述:该函数用于计算某段时间内最大和最小值得差值,用于聚合函数的数据最终处理过程。
参数:s real[]
返回值类型:real
- spread_internal
描述:该函数用于计算某段时间内最大和最小值得差值,用于聚合函数的数据中间过程。
参数:s real[], v real
返回值类型:real[]
- xidin4
参数:cstring
返回值类型:xid32
- set_hashbucket_info
参数:text
返回值类型:boolean
- gap_fill_internal
参数:s anyelement, v anyelement
返回值类型:anyelement
- int1send
参数:tinyint
返回值类型:bytea
- is_contain_namespace
描述:查找表名和namespace分割的位置,如果不存在namespace,返回0。
参数:relationname name
返回值类型:integer
- is_oid_in_group_members
参数:node_oid oid, group_members oidvector_extend。
返回值类型:boolean
- isubmit_on_nodes_internal
参数:job bigint, node_name name, database name, what text, next_date timestamp without time zone, job_interval text
返回值类型:integer
- listagg
参数:smallint, text
返回值类型:text
- log_fdw_validator
参数:text[], oid
返回值类型:void
- nvarchar2typmodin
参数:cstring[]
返回值类型:integer
- nvarchar2typmodout
描述:获取varchar的typmod信息,并构造字符串返回。
参数:integer
返回值类型:cstring
- pg_nodes_memmon
参数:nan
返回值类型:innernname text, innerusedmem bigint, innertopctxt bigint, nname text, usedmem text, sharedbuffercache text, topcontext text
- 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, storage_type oid, reltablespace oid, reldatabase oid, relforknumber smallint, relblocknumber bigint, isdirty boolean, usage_count smallint
- pg_check_xidlimit
描述:判断nextxid是否>= xidwarnlimit。
参数:nan
返回值类型:boolean
- 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_pool_validate
描述:通过比较pgxc_node系统表中的字段,验证连接是否可用。
参数:clear boolean, co_node_name cstring
返回值类型:pid bigint, node_name text
- pg_resume_bkp_flag
参数:slot_name name
返回值类型:start_backup_flag boolean, to_delay boolean, ddl_delay_recycle_ptr text, rewind_time text
- pg_stat_get_pooler_status
参数:nan
返回值类型:text、 text、 bigint、 text、 bigint、 boolean、 text、 bigint、 bigint、 bigint、 bigint、 bigint
表1 PG_STAT_GET_POOLER_STATUS字段 名称
类型
描述
database_name
OUT text
数据库名称。
user_name
OUT text
用户名。
tid
OUT bigint
非线程池逻辑下为连接CN的线程id,线程池逻辑下为连接CN的sessionid。
pgoptions
OUT text
数据库连接选项,详见连接参数描述的options字段。
node_oid
OUT bigint
连接的实例节点OID。
in_use
OUT boolean
连接是否正被使用。- t(true):表示连接正在使用。
- f(false):表示连接没有使用。
session_params
OUT text
由此连接下发的GUC session参数。
fdsock
OUT bigint
本端socket。
remote_pid
OUT bigint
对端线程号。
used_count
OUT bigint
该连接的复用次数。
idx
OUT bigint
通信对端DN在本CN内的标识编号。
streamid
OUT bigint
通信流在物理连接中的标识编号。
- psortoptions
参数:text[], boolean
返回值类型:bytea
- remove_job_class_depend
参数:oid
返回值类型:void
- xideq4
参数:xid32, xid32
返回值类型:boolean
- xideqint8
参数:xid, bigint
返回值类型:boolean
- xidlt
参数:xid, xid
返回值类型:boolean
- xidlt4
参数:xid32, xid32
返回值类型:boolean
- get_local_cont_query_stat
参数:cq_id oid
返回值类型:cq oid, w_in_rows int8, w_in_bytes int8, w_out_rows int8, w_out_bytes int8, w_pendings int8, w_errors int8, r_in_rows int8, r_in_bytes int8, r_out_rows int8, r_out_bytes int8, r_errors int8, c_in_rows int8, c_in_bytes int8, c_out_rows int8, c_out_bytes int8, c_pendings int8, c_errors int8
- get_local_cont_query_stats
参数:nan
返回值类型:cq oid, w_in_rows int8, w_in_bytes int8, w_out_rows int8, w_out_bytes int8, w_pendings int8, w_errors int8, r_in_rows int8, r_in_bytes int8, r_out_rows int8, r_out_bytes int8, r_errors int8, c_in_rows int8, c_in_bytes int8, c_out_rows int8, c_out_bytes int8, c_pendings int8, c_errors int8
- get_cont_query_stats
参数:nan
返回值类型:node name, cq oid, w_in_rows int8, w_in_bytes int8, w_out_rows int8, w_out_bytes int8, w_pendings int8, w_errors int8, r_in_rows int8, r_in_bytes int8, r_out_rows int8, r_out_bytes int8, r_errors int8, c_in_rows int8, c_in_bytes int8, c_out_rows int8, c_out_bytes int8, c_pendings int8, c_errors int8
- reset_local_cont_query_stat
参数:cq_id oid
返回值类型:boolean
- reset_local_cont_query_stats
参数:cq_id oid
返回值类型:boolean
- reset_cont_query_stats
描述:复位各个DN节点的STREAM对象对应的持续计算视图统计信息。
参数:stream_id oid
返回值类型:boolean
- check_cont_query_schema_changed
描述:判断指定持续计算视图的schema change状态。
参数:cq_id oid
返回值类型:boolean
- gs_get_standby_cluster_barrier_status
描述:查看备cn/dn的barrier日志回放情况,包括已接收到的最新barrier点、已接收到的最新barrier点的LSN,上一次回放的barrier点,回放的目标barrier点。
参数:nan
返回值类型:barrier_id text,barrier_lsn text,recovery_id text,target_id text
备注:调用该函数的用户需要具有SYSADMIN权限或具有OPRADMIN权限,运维管理员角色须打开operate_mode。
- gs_set_standby_cluster_target_barrier_id
参数:barrier_id字符串
返回值类型:target_id text
备注:调用该函数的用户需要具有SYSADMIN权限或具有OPRADMIN权限,运维管理员角色须打开operate_mode。
- gs_query_standby_cluster_barrier_id_exist
参数:barrier_id字符串
返回值类型:boolean
备注:调用该函数的用户需要具有SYSADMIN权限或具有OPRADMIN权限,运维管理员角色须打开operate_mode。
以下流函数虽存在但功能尚未支持,不建议使用:
streaming_int8_avg_gather、streaming_numeric_avg_gather、streaming_float8_avg_gather、streaming_interval_avg_gather、streaming_int8_sum_gather、streaming_int2_int4_sum_gather