14th September 2023: PostgreSQL 16 Released!
Unsupported versions: 7.0 / 6.5 / 6.4
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

Chapter 5. Functions

Describes the built-in functions available in Postgres.

Many data types have functions available for conversion to other related types. In addition, there are some type-specific functions. Some functions are also available through operators and may be documented as operators only.

SQL Functions

SQL functions are constructs defined by the SQL92 standard which have function-like syntax but which can not be implemented as simple functions.

Table 5-1. SQL Functions

Function Returns Description Example
COALESCE(list) non-NULL return first non-NULL value in list COALESCE(rle, c2 + 5, 0)
NULLIF(input,value) input or NULL return NULL if input = value, else input NULLIF(c1, 'N/A')
CASE WHEN expr THEN expr [...] ELSE expr END expr return expression for first true WHEN clause CASE WHEN c1 = 1 THEN 'match' ELSE 'no match' END