Re: GENERATE_SERIES is not available in the command-line shell

> > Is it going to be fixed in 3.31?
>
> I'll fix the documentation, so that it doesn't say that any more, if
> that is what you mean by "fixed".  :-)
>
> Hoped to have it compiled in by default :-) It'd be nice addition... Come
on, typical Linux or Windows has multiple gigabytes of memory... I'm not
talking about enabling it by default for resource-constrained builds.

Thanks for the response anyway.


> You can use a recursive common table expression in place of
> generated_series().  Like this:
>
> WITH generate_series(value) AS (
>   VALUES($START)
>   UNION ALL
>   SELECT value + $STEP FROM generate_series
>     WHERE value $ STEP <= $STOP
> )
> SELECT value FROM generate_series;
>
> This is more typing, I know.  But it is the official SQL standard way
> of getting an ascending list of integers.
>
>
I would prefer more PostgreSQL'ish way of accomplishing the same :-)
It's crazy useful for ad-hoc one-liner queries to generate lots of data.
Have a good day!
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users