7.6.1. Assignment Statements
Used for
Assigning a value to a variable
Available in
PSQL
Syntax
varname = <value_expr>
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 equivalence symbol (‘=
’) as its assignment operator. The assignment statement assigns an 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 or to external functions (UDFs).
Example using assignment statements
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
See also