Built-in Functions and Operators

This chapter provides an overview of built-in functions and operators.

Operators are reserved keywords that are primarily used in a WHERE Clause to perform arithmetic operations or comparisons.

Table of Contents

• Scalar Functions
  • String Functions
  • Date and Time Functions
  • Geo Functions
  • Mathematical Functions
  • Regular Expression Functions
  • Array Functions
  • Conditional Functions and Expressions
  • System Information Functions
  • Special Functions
• Aggregation
  • Introduction
  • count
  • min
  • max
  • sum
  • avg and mean
  • geometric_mean
  • variance
  • stddev
  • percentile
  • arbitrary
  • hyperloglog_distinct
  • Limitations
• Arithmetic Operators
  • Supported operators
  • Result types
• Table Functions
  • empty_row( )
  • unnest( array [ array , ] )
  • generate_series(start, stop, [step])
• Comparison Operators
• Array Comparisons
  • IN (value [, ...])
  • ANY/SOME (array expression)
• Subquery Expressions
  • IN (subquery)
  • ANY/SOME (subquery)
• Window Functions
  • Introduction
  • Window Definition
  • General-Purpose Window Functions
  • Aggregate Window Functions