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