Query syntax
Query syntax
Syntax and usage of common query clauses.
Logical operators
Operators for logical operations.
Comparison functions and operators
Functions and operators for comparing values.
Mathematical functions and operators
Functions and operators for mathematical operations.
String functions and operators
Functions and operators for string manipulation.
Binary string functions and operators
Functions and operators for binary string operations.
Date/time functions and operators
Functions and operators for date and time operations.
Cryptographic functions
Functions for cryptographic operations.
JSON functions and operators
Functions and operators for JSON data.
Array functions and operators
Functions and operators for array operations.
Map functions and operators
Functions and operators for map data structures.
Conditional expressions
Expressions for conditional logic, such as CASE statements.
Aggregate functions
Functions that compute a single result from a set of input values.
Window functions
Functions that operate on a set of rows related to the current row.
Set-returning functions
Functions that return a set of rows, such as generate_series().
System administration functions
Functions for system administration tasks in RisingWave and PostgreSQL.
System information functions
Functions to retrieve system information about database, schema, user, role, session, etc.