DECLARE#
Synopsis#
DECLARE identifier [, ...] type [ DEFAULT expression ]
Description#
Use the DECLARE statement directly after the BEGIN keyword in
SQL user-defined functions to define one or more variables with an identifier as name. Each
statement must specify the data type of the variable with
type. It can optionally include a default, initial value defined by an
expression. The default value is NULL if not specified.
Examples#
A simple declaration of the variable x with the tinyint data type and the
implicit default value of null:
DECLARE x tinyint;
A declaration of multiple string variables with length restricted to 25 characters:
DECLARE first_name, last_name, middle_name varchar(25);
A declaration of an exact decimal number with a default value:
DECLARE uptime_requirement decimal DEFAULT 99.999;
A declaration with a default value from an expression:
DECLARE start_time timestamp(3) with time zone DEFAULT now();
Further examples of varying complexity that cover usage of the DECLARE
statement in combination with other statements are available in the
Example SQL UDFs.