Assignment Statements

Syntax

Figure 1 shows the syntax diagram for assigning a value to a variable.

Figure 1 assignment_value::=

The above syntax diagram is explained as follows:

• variable_name indicates the name of a variable.
• value can be a value or an expression. The type of value must be compatible with the type of variable_name.

Example

postgres=# DECLARE
    emp_id  INTEGER := 7788; --Assignment
BEGIN
    emp_id := 5; --Assignment
    emp_id := 5*7784;
END;
/