Aggregate
Aggregate functions compute a single result from a set of input values.
Array
Array functions
Binary string
bit_length
Cast
Use the cast function and operator to convert a value to a specific type.
Conditional
CASE
Comparison
Comparison operators
Cryptographic
Cryptographic functions.
Date & time
Timespan operators
JSON
JSON functions
Logical
| Operator | Expression & Description |
Mathematical
Mathematical operators
Set functions
generate_series()
Set operators
UNION and UNION ALL
String
String operators
System administration
This page lists both RisingWave system administration functions and PostgreSQL system administration functions that are supported in RisingWave.
System information
RisingWave provides functions to help you get system information, including database, schema, user, role, session, and more.