Built-in functions and operators

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

• 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