Forgot to mention that I sees the issue as fundamentally distinct from
the Mandelbrot example in the SQLite docs: it uses a construct
-outlined in procedural statements- like:
For x in xRange
For y in yRange
compute something like f(x, y) -- here, y is independant of x
Next y
Next x
Put in table form:
build a table for varying x's
build a table for varying y's
compute f(x, y) for the cross join
My issue is that yRange depends on the current x for its starting
point, so in SQL WITH parlance, I can't have a table x built before
entering the computation.
It must be simple but I lamentably fail to see the light.
