There are a few pseudo-variables which have special functions in the expression language. The following specials are column-like, in that they have a different value for each row:
long
(8-byte integer);
when using it in certain expressions you may find it necessary to convert
it to an int
(4-byte integer) using the
toInteger()
function.
The deprecated alias "INDEX
" may also be used.
0<=x<1
with a value which is fixed for a given row in this expression.
The quality of the random numbers may not be particularly good.
The deprecated alias "RANDOM
" may also be used.
The following specials are parameter-like, in that their value is not sensitive to the row:
long
(8-byte integer);
when using it in certain expressions you may find it necessary to convert
it to an int
(4-byte integer) using the
toInteger()
function.