RANGE(QUEL) 2/29/79 RANGE(QUEL) NAME range - declare a variable to range over a relation SYNOPSIS range of variable is relname DESCRIPTION Range is used to declare variables which will be used in subsequent QUEL statements. The variable is associated with the relation specified by relname. When the variable is used in subsequent statements it will refer to a tuple in the named relation. A range declaration remains in effect for an entire INGRES session (until exit from INGRES), until the variable is redeclared by a subsequent range statement, or until the relation is removed with the destroy command. EXAMPLE /* Declare tuple variable e to range over relation emp */ range of e is emp SEE ALSO quel(quel), destroy(quel) BUGS Only 10 variable declarations may be in effect at any time. After the 10th range statement, the least recently referenced variable is re-used for the next range statement. - 1 -