The syntax for a function call is as follows:
function_name "(" [argument [, argument, ...]] ")"
Here function_name is a possibly qualified name of a
function, and argument is an expression optionally
prefixed with an argument name and the assignment operator (
For example, the following computes the length of a string
Many built-in and user-defined functions operate on elements, so they are element-wise operations. This implies that if any of the input sets are empty, the result of applying an element function is also empty.
# count maps a set to an integer, specifically it returns the # number of elements in a set SELECT count(example::Issue); # array_agg maps a set to an array of the same type, specifically # it returns the array made from all of the set elements (which # can also be ordered) WITH MODULE example SELECT array_agg(Issue ORDER BY Issue.number);