Functions are used to return information from the database. They can be called anywhere an expression is allowed.

Unless otherwise specified in the documentation, NULL is returned for a function if any argument is NULL.

If an argument is optional, DEFAULT can be provided as an argument.

Functions use the same syntax conventions used by SQL statements.

 See also