SQL functions and operators

Functions and operators that can be used in SQL queries.

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.

Assistant

Responses are generated using AI and may contain mistakes.