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