![Functions and operators [YSQL]](/images/section_icons/api/ysql.png "Functions and operators [YSQL]"){kind=icon}
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 |