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.
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
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.