Assignment Statements

Assigns a value to a variable

Syntax

varname = <value_expr>;

Table 1. Assignment Statement Parameters
Argument	Description
varname	Name of a parameter or local variable
value_expr	An expression, constant or variable whose value resolves to the same data type as varname

PSQL uses the equal symbol (‘=’) as its assignment operator.The assignment statement assigns a SQL expression value on the right to the variable on the left of the operator.The expression can be any valid SQL expression: it may contain literals, internal variable names, arithmetic, logical and string operations, calls to internal functions, stored functions or external functions (UDFs).

CREATE PROCEDURE MYPROC ( a INTEGER, b INTEGER, name VARCHAR (30) ) RETURNS ( c INTEGER, str VARCHAR(100)) AS BEGIN -- assigning a constant c = 0; str = ''; SUSPEND; -- assigning expression values c = a + b; str = name || CAST(b AS VARCHAR(10)); SUSPEND; -- assigning expression value built by a query c = (SELECT 1 FROM rdb$database); -- assigning a value from a context variable str = CURRENT_USER; SUSPEND; END

Assignment Statements

Assignment Statements

Example using assignment statements