NexusDB Manual V3 > SQL Reference > SQL Statements > Control Statements
Exit from an iterated statement.
Syntax
<leave statement> ::= LEAVE
Usage
The LEAVE statement can only be specified in the body of the REPEAT and WHILE statements to stop the iteration and exit the statement.
See also: ITERATE statement
Examples
DROP FUNCTION IF EXISTS dummyFunc; CREATE FUNCTION dummyFunc( p1 INTEGER ) RETURNS INTEGER BEGIN DECLARE v1, v2 INTEGER; SET v1 = 10; SET v2 = 10; WHILE v1 > 0 DO SET v1 = v1 - 1; IF v1 >= 5 THEN LEAVE; END IF; SET v2 = v2 - 1; END WHILE; RETURN v2 + p1; END; SELECT dummyFunc( 15 ) FROM #dummy;
Conformance
|
© Nexus Database Systems Pty Ltd.