![Built-in functions and operators [YSQL]](/images/section_icons/api/subsection.png "Built-in functions and operators [YSQL]"){kind=icon}
Built-in functions and operators
Contribute
This page documents the preview version (v2.21). Preview includes features under active development and is for development and testing only. For production, use the stable version (v2024.1). To learn more, see Versioning.
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 |