v2.25 Preview Preview release - not for production v2024.2 LTS Stable release with long-term support v2024.1 STS Stable release with standard-term support v2.20 LTS Stable release with long-term support v2.18 STS Stable release with standard-term support v2.14 LTS Stable release with long-term support Unsupported versions
Built-in functions and operators [YSQL]

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