> > 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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
