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
nextval() Returns the next value for the specified sequence in the current session
currval() Returns the value returned by the most recent call to nextval() for the specified sequence in the current session
lastval() Returns the value returned by the most recent call to nextval() for any sequence in the current session
yb_hash_code() Returns the partition hash code for a given set of expressions
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