Scalar Functions (Detailed Reference)
This section provides per-function documentation for all scalar functions currently wired by MonkDB's scalar registry.
Coverage and Validation
- Function inventory is source-driven from ScalarFunctions module registrations and dynamic aliases.
- For your running cluster build, verify concrete overloads with pg_catalog.pg_proc.
- Internal/engine compatibility functions are documented separately and marked accordingly.
How to Use This Section
- Start in the category index below.
- Open a function page for syntax, behavior, and examples.
- Validate final overload signatures in your environment using discovery queries.
Arrays and Collections
- array_append
- array_avg
- array_cat
- array_difference
- array_intersect
- array_length
- array_lower
- array_max
- array_min
- array_position
- array_prepend
- array_remove
- array_reverse
- array_set
- array_slice
- array_sort
- array_sum
- array_to_string
- array_union
- array_unique
- array_unnest
- array_upper
- cardinality
- collection_avg
- collection_count
- string_to_array
Conditional and Null Handling
Date and Time
- age
- curdate
- current_time
- current_timestamp
- date_add
- date_bin
- date_format
- date_part
- date_sub
- date_trunc
- extract_century
- extract_day
- extract_day_of_month
- extract_day_of_week
- extract_day_of_year
- extract_epoch
- extract_hour
- extract_minute
- extract_month
- extract_quarter
- extract_second
- extract_week
- extract_year
- from_unixtime
- make_interval
- now
- timezone
- to_timestamp
Geospatial
Graph
Internal and Engine Compatibility
JSON and Object
- json_array_length
- json_contains
- json_delete_path
- json_each
- json_extract_path
- json_extract_path_text
- json_has_key
- json_object_keys
- json_remove
- json_set
- json_typeof
- jsonb_set
- object_keys
- object_merge
- object_values
- parse_uri
- parse_url
Numeric and Analytics
- abs
- acos
- add
- and
- asin
- atan
- atan2
- bucket
- ceil
- ceiling
- cos
- cot
- degrees
- divide
- exp
- floor
- ln
- log
- mod
- modulus
- multiply
- normalize
- or
- percentile_cont
- pi
- power
- radians
- random
- round
- sign
- sin
- sqrt
- subtract
- tan
- trunc
- width_bucket
- xor
- zscore
Other
Postgres Compatibility and System
- col_description
- current_database
- current_schema
- current_schemas
- current_setting
- format_type
- obj_description
- pg_backend_pid
- pg_encoding_to_char
- pg_function_is_visible
- pg_get_expr
- pg_get_function_result
- pg_get_partkeydef
- pg_get_serial_sequence
- pg_get_userbyid
- pg_postmaster_start_time
- pg_table_is_visible
- pg_typeof
- version
Privileges and Security
String and Text
- ascii
- bit_length
- btrim
- char_length
- chr
- concat
- concat_ws
- decode
- encode
- format
- gen_random_text_uuid
- gen_random_uuid
- hash
- initcap
- left
- length
- lower
- lpad
- ltrim
- md5
- octet_length
- quote_ident
- regexp_like
- regexp_match
- regexp_matches
- regexp_replace
- regexp_split_to_array
- repeat
- replace
- reverse
- right
- rpad
- rtrim
- sha1
- split_part
- string_to_timestamp
- strpos
- substr
- substring
- to_char
- translate
- trim
- upper
- uuid_generate_v4