Built-in functions and operators

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

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
  • Aggregate expressions
  • Aggregate functions
  • Limitations
• Arithmetic operators
• Table functions
  • Scalar functions
  • empty_row( )
  • unnest( array [ array , ] )
  • pg_catalog.generate_series(start, stop, [step])
  • pg_catalog.generate_subscripts(array, dim, [reverse])
  • regexp_matches(source, pattern [, flags])
  • pg_catalog.pg_get_keywords()
  • information_schema._pg_expandarray(array)
• Comparison operators
  • Basic operators
  • WHERE clause operators
• Array comparisons
  • IN (value [, ...])
  • ANY/SOME (array expression)
  • ALL (array_expression)
• Subquery expressions
  • IN (subquery)
  • ANY/SOME (subquery)
  • ALL (subquery)
• Window functions
  • Window function call
  • Window definition
  • General-purpose window functions
  • Aggregate window functions