> ## Documentation Index
> Fetch the complete documentation index at: https://docs.risingwave.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SQL functions and operators

> Functions and operators that can be used in SQL queries.

<CardGroup>
  <Card title="Logical operators" icon="plus" iconType="solid" href="/sql/functions/logical"> Operators for logical operations. </Card>
  <Card title="Comparison functions and operators" icon="equals" iconType="solid" href="/sql/functions/comparison"> Functions and operators for comparing values. </Card>
  <Card title="Mathematical functions and operators" icon="calculator" iconType="solid" href="/sql/functions/mathematical"> Functions and operators for mathematical operations. </Card>
  <Card title="String functions and operators" icon="font" iconType="solid" href="/sql/functions/string"> Functions and operators for string manipulation. </Card>
  <Card title="Binary string functions and operators" icon="binary" iconType="solid" href="/sql/functions/binarystring"> Functions and operators for binary string operations. </Card>
  <Card title="Date/time functions and operators" icon="calendar" iconType="solid" href="/sql/functions/datetime"> Functions and operators for date and time operations. </Card>
  <Card title="Cryptographic functions" icon="lock" iconType="solid" href="/sql/functions/cryptographic"> Functions for cryptographic operations. </Card>
  <Card title="JSON functions and operators" icon="brackets-curly" iconType="solid" href="/sql/functions/json"> Functions and operators for JSON data. </Card>
  <Card title="Array functions and operators" icon="brackets-square" iconType="solid" href="/sql/functions/array"> Functions and operators for array operations. </Card>
  <Card title="Map functions and operators" icon="map" iconType="solid" href="/sql/functions/map"> Functions and operators for map data structures. </Card>
  <Card title="Conditional expressions" icon="code-branch" iconType="solid" href="/sql/functions/conditional"> Expressions for conditional logic, such as CASE statements. </Card>
  <Card title="Aggregate functions" icon="chart-column" iconType="solid" href="/sql/functions/aggregate"> Functions that compute a single result from a set of input values. </Card>
  <Card title="Window functions" icon="window-maximize" iconType="solid" href="/sql/functions/window-functions"> Functions that operate on a set of rows related to the current row. </Card>
  <Card title="Set-returning functions" icon="table-list" iconType="solid" href="/sql/functions/set-returning"> Functions that return a set of rows, such as generate\_series(). </Card>
  <Card title="System administration functions" icon="screwdriver-wrench" iconType="solid" href="/sql/functions/sys-admin"> Functions for system administration tasks in RisingWave and PostgreSQL. </Card>
  <Card title="System information functions" icon="circle-info" iconType="solid" href="/sql/functions/sys-info"> Functions to retrieve system information about database, schema, user, role, session, etc. </Card>
</CardGroup>