Built-in functions and operators

YSQL supports all PostgreSQL-compatible built-in functions and operators. The following are the currently documented ones.

Statement	Description
yb_hash_code()	Returns the partition hash code for a given set of expressions
gen_random_uuid()	Returns a random UUID
Sequence functions	Functions operating on sequences
Geo-partitioning helper functions	Detailed list of geo-partitioning helper functions
JSON functions and operators	Detailed list of JSON-specific functions and operators
Array functions and operators	Detailed list of array-specific functions and operators
Aggregate functions	Detailed list of YSQL aggregate functions
Window functions	Detailed list of YSQL window functions
Date-time operators	List of operators for the date and time data types
General-purpose date-functions	List of general purpose functions for the date and time data types
Date-time formatting functions	List of formatting functions for the date and time data types