DoubleRange
Signatures
DOUBLE DoubleRange(DOUBLE begin, DOUBLE end);
DOUBLE DoubleRange(DOUBLE begin, DOUBLE end, DOUBLE step);
Description
Return an array of doubles within the range [start
-end
[.
The default increment value is 1 but the user can set another one specifying the step
parameter.
Remarks
end
is excluded from the array,end
has to be greater thanbegin
otherwiseDoubleRange
will throw an exception.
Examples
SELECT DoubleRange(2, 7);
-- Answer:
2, 3, 4, 5, 6
SELECT DoubleRange(0, 6, 2);
-- Answer:
0, 2, 4
SELECT DoubleRange(0, 1, 0.5);
-- Answer:
0, 0.5