Skip to content

Scalar Function Matrix

Function Category Reference
array_append Arrays and Collections Open
array_avg Arrays and Collections Open
array_cat Arrays and Collections Open
array_difference Arrays and Collections Open
array_intersect Arrays and Collections Open
array_length Arrays and Collections Open
array_lower Arrays and Collections Open
array_max Arrays and Collections Open
array_min Arrays and Collections Open
array_position Arrays and Collections Open
array_prepend Arrays and Collections Open
array_remove Arrays and Collections Open
array_reverse Arrays and Collections Open
array_set Arrays and Collections Open
array_slice Arrays and Collections Open
array_sort Arrays and Collections Open
array_sum Arrays and Collections Open
array_to_string Arrays and Collections Open
array_union Arrays and Collections Open
array_unique Arrays and Collections Open
array_unnest Arrays and Collections Open
array_upper Arrays and Collections Open
cardinality Arrays and Collections Open
collection_avg Arrays and Collections Open
collection_count Arrays and Collections Open
string_to_array Arrays and Collections Open
case Conditional and Null Handling Open
coalesce Conditional and Null Handling Open
greatest Conditional and Null Handling Open
if Conditional and Null Handling Open
least Conditional and Null Handling Open
null_or_empty Conditional and Null Handling Open
nullif Conditional and Null Handling Open
age Date and Time Open
curdate Date and Time Open
current_time Date and Time Open
current_timestamp Date and Time Open
date_add Date and Time Open
date_bin Date and Time Open
date_format Date and Time Open
date_part Date and Time Open
date_sub Date and Time Open
date_trunc Date and Time Open
extract_century Date and Time Open
extract_day Date and Time Open
extract_day_of_month Date and Time Open
extract_day_of_week Date and Time Open
extract_day_of_year Date and Time Open
extract_epoch Date and Time Open
extract_hour Date and Time Open
extract_minute Date and Time Open
extract_month Date and Time Open
extract_quarter Date and Time Open
extract_second Date and Time Open
extract_week Date and Time Open
extract_year Date and Time Open
from_unixtime Date and Time Open
make_interval Date and Time Open
now Date and Time Open
timezone Date and Time Open
to_timestamp Date and Time Open
area Geospatial Open
distance Geospatial Open
geohash Geospatial Open
intersects Geospatial Open
latitude Geospatial Open
longitude Geospatial Open
within Geospatial Open
graph_edges Graph Open
graph_neighbors Graph Open
graph_shortest_path Graph Open
graph_vertices Graph Open
_array Internal and Engine Compatibility Open
_cast Internal and Engine Compatibility Open
_negate Internal and Engine Compatibility Open
_subscript_record Internal and Engine Compatibility Open
cast Internal and Engine Compatibility Open
ignore3vl Internal and Engine Compatibility Open
subscript Internal and Engine Compatibility Open
subscript_obj Internal and Engine Compatibility Open
try_cast Internal and Engine Compatibility Open
json_array_length JSON and Object Open
json_contains JSON and Object Open
json_delete_path JSON and Object Open
json_each JSON and Object Open
json_extract_path JSON and Object Open
json_extract_path_text JSON and Object Open
json_has_key JSON and Object Open
json_object_keys JSON and Object Open
json_remove JSON and Object Open
json_set JSON and Object Open
json_typeof JSON and Object Open
jsonb_set JSON and Object Open
object_keys JSON and Object Open
object_merge JSON and Object Open
object_values JSON and Object Open
parse_uri JSON and Object Open
parse_url JSON and Object Open
abs Numeric and Analytics Open
acos Numeric and Analytics Open
add Numeric and Analytics Open
and Numeric and Analytics Open
asin Numeric and Analytics Open
atan Numeric and Analytics Open
atan2 Numeric and Analytics Open
bucket Numeric and Analytics Open
ceil Numeric and Analytics Open
ceiling Numeric and Analytics Open
cos Numeric and Analytics Open
cot Numeric and Analytics Open
degrees Numeric and Analytics Open
divide Numeric and Analytics Open
exp Numeric and Analytics Open
floor Numeric and Analytics Open
ln Numeric and Analytics Open
log Numeric and Analytics Open
mod Numeric and Analytics Open
modulus Numeric and Analytics Open
multiply Numeric and Analytics Open
normalize Numeric and Analytics Open
or Numeric and Analytics Open
percentile_cont Numeric and Analytics Open
pi Numeric and Analytics Open
power Numeric and Analytics Open
radians Numeric and Analytics Open
random Numeric and Analytics Open
round Numeric and Analytics Open
sign Numeric and Analytics Open
sin Numeric and Analytics Open
sqrt Numeric and Analytics Open
subtract Numeric and Analytics Open
tan Numeric and Analytics Open
trunc Numeric and Analytics Open
width_bucket Numeric and Analytics Open
xor Numeric and Analytics Open
zscore Numeric and Analytics Open
try_parse_date Other Open
try_parse_number Other Open
try_parse_timestamp Other Open
col_description Postgres Compatibility and System Open
current_database Postgres Compatibility and System Open
current_schema Postgres Compatibility and System Open
current_schemas Postgres Compatibility and System Open
current_setting Postgres Compatibility and System Open
format_type Postgres Compatibility and System Open
obj_description Postgres Compatibility and System Open
pg_backend_pid Postgres Compatibility and System Open
pg_encoding_to_char Postgres Compatibility and System Open
pg_function_is_visible Postgres Compatibility and System Open
pg_get_expr Postgres Compatibility and System Open
pg_get_function_result Postgres Compatibility and System Open
pg_get_partkeydef Postgres Compatibility and System Open
pg_get_serial_sequence Postgres Compatibility and System Open
pg_get_userbyid Postgres Compatibility and System Open
pg_postmaster_start_time Postgres Compatibility and System Open
pg_table_is_visible Postgres Compatibility and System Open
pg_typeof Postgres Compatibility and System Open
version Postgres Compatibility and System Open
has_database_privilege Privileges and Security Open
has_schema_privilege Privileges and Security Open
has_table_privilege Privileges and Security Open
ascii String and Text Open
bit_length String and Text Open
btrim String and Text Open
char_length String and Text Open
chr String and Text Open
concat String and Text Open
concat_ws String and Text Open
decode String and Text Open
encode String and Text Open
format String and Text Open
gen_random_text_uuid String and Text Open
gen_random_uuid String and Text Open
hash String and Text Open
initcap String and Text Open
left String and Text Open
length String and Text Open
lower String and Text Open
lpad String and Text Open
ltrim String and Text Open
md5 String and Text Open
octet_length String and Text Open
quote_ident String and Text Open
regexp_like String and Text Open
regexp_match String and Text Open
regexp_matches String and Text Open
regexp_replace String and Text Open
regexp_split_to_array String and Text Open
repeat String and Text Open
replace String and Text Open
reverse String and Text Open
right String and Text Open
rpad String and Text Open
rtrim String and Text Open
sha1 String and Text Open
split_part String and Text Open
string_to_timestamp String and Text Open
strpos String and Text Open
substr String and Text Open
substring String and Text Open
to_char String and Text Open
translate String and Text Open
trim String and Text Open
upper String and Text Open
uuid_generate_v4 String and Text Open
knn_match Vector Open
vector_similarity Vector Open