Functions and operators

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

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