Built-in functions and operators [YSQL]

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

Statement	Description
{{<tags/feature/ea idea="2160">}}yb_index_check()	Checks if the given index is consistent with its base relation
yb_hash_code()	Returns the partition hash code for a given set of expressions
yb_servers()	Returns a list of all the nodes in your cluster and their location
yb_cancel_transaction()	Cancels a specific transaction
Sequence functions	Functions operating on sequences
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