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