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 Object functions Conditional functions and expressions System information functions Special functions Vector functions Aggregation Aggregate expressions Aggregate functions Limitations Arithmetic operators Bit 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