Logical operators
| Operator | Expression & Description |
Comparison functions and operators
Comparison operators
Mathematical functions and operators
Mathematical operators
String functions and operators
String operators
Binary string functions and operators
bit_length
Date/time functions and operators
Timespan operators
Cryptographic functions
Cryptographic functions.
JSON functions and operators
JSON functions
Array functions and operators
Array functions
Map functions and operators
Map functions
Conditional expressions
CASE
Aggregate functions
Aggregate functions compute a single result from a set of input values.
Window functions
Window functions compute a single result for each row over a set of rows that are related to the current row (the "window").
Set-returning functions
generate_series()
System administration functions
This page lists both RisingWave system administration functions and PostgreSQL system administration functions that are supported in RisingWave.
System information functions
RisingWave provides functions to help you get system information, including database, schema, user, role, session, and more.