sql - How do I generate a (dummy) column of arbitrary length with MonetDB? -

i run equivalent of postgresql's

select * generate_series(1, 10000000) 

i've read this:

http://blog.jooq.org/2013/11/19/how-to-create-a-range-from-1-to-10-in-sql/

but suggestions there don't take arbitrary length - query depends on length otherwise replacing number. also, suggestions not apply in monetdb. so, what's best course of action (if any)?

notes: - i'm using version february 2013. answers more recent features welcome, i'm looking for. - assume existing tables don't have enough lines; , not assume that, say, cartesian product of longest table sufficient (or alternatively, maybe that's costly perform).

try with:

select value sys.generate_series(initial_value, end_value, offset); 

i have report function quite unstable on jul2015 release causing server process crash. hope have better luck.

if wants generate arbitrary numeric value can use:

select rand();