Routines
RETURN
Synopsis
RETURN expression
Description
Provide the value from a SQL routines to the caller. The value is the result of evaluating the expression. It can be a static value, a declared variable or a more complex expression.
Examples
The following examples return a static value, the result of an expression, and the value of the variable x:
RETURN 42;
RETURN 6 * 7;
RETURN x;
Further examples of varying complexity that cover usage of the RETURN
statement in combination with other statements are available in the SQL
routines examples documentation.
All routines must contain a RETURN
statement at the end of the top-level
block in the FUNCTION
declaration, even if it’s unreachable.